Hi all,
I'd like to run my macro without actually seeing the screen flick between the various worksheets it selects during its run time. Is this possible?
Thanks very much!
Brian
Hi all,
I'd like to run my macro without actually seeing the screen flick between the various worksheets it selects during its run time. Is this possible?
Thanks very much!
Brian
Just add
at the beginning of your codeApplication.ScreenUpdating = False
Remember to turn it back on
Please Login or Register to view this content.
That's great, thanks to both of you.
What happens if you don't add it back on at the end? I never do and I have never noticed any problems.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks