I am the Technical Sales Manager for one of the countries leading specialists in Whole House Automation and Entertainment systems. Below is a blend of my thoughts and opinions about Home Automation and some technical solutions that I have found over the years. For more visit my website www.chrisnew.co.uk.
Tuesday, 22 June 2010
Speeding up VBA Macros in Excel
I have stumbled upon a good way to speed up macros in Excel. If you use the Application.ScreenUpdating = False argument at the beginning of the macro, then the macro will not display what it is doing. Then when you use the argument Application.ScreenUpdating = True at the end of the macro everything the macro has done will become visible. This works well in speeding up long and complex macros.
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment