Speed up a macro

Just saw an Excel newsletter post from Kevin Jones from https://www.dataautopros.com/about-us/

He found that turning off the VBA interactive setting can speed up some macros. I tested it on a one minute macro and it cut it down to 40 seconds.

Worth a try if you have a longer running macro. You can add it to your opening and closing routines.

Code to turn it off

Application.Interactive = False

And then turn it back on at the end of your code.

Application.Interactive = True

Thanks Kevin for sharing.

Related Posts

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.