Screen updating hidden in vba
Therefore, if you're saving an Excel 2007-2010 workbook as an Excel 97-2003 workbook, make sure that there are no compatibility issues or that only minor ones exist. Using helpful habits Making your work more efficient This chapter contains a list of ten clever tricks I’ve developed (or acquired from other users) over the years.
To return the status bar back to normal, execute the following statement: Declaring every variable that you use in your code is an excellent practice. Place a check mark next to Require Variable Declaration.
My question is why on earth would this macro take 10-15minutes to run? End Sub Sub Hide No Slackers() Dim cell As Range, rng As Range, rng Hide As Range Set rng = Sheets("CONSOLIDATED DATA").