I have been working in the Home Automation industry since 2007, prior to that I studied Sound Engineering as a science at The University of Plymouth. Below is a blend of my thoughts and opinions about Home Automation and some technical solutions that I have found over the years.
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)
No comments:
Post a Comment