Quick Question regarding VBA and Application.ScreenUpdating=False

jase71ds

Board Regular
Joined
Oct 23, 2006
Messages
104
I almost never want to see the screen update when I run a macro (unless I'm troubleshooting)
I've gotten into the habit of begining all macros with:
Application.ScreenUpdating=False

But I've also got in the habit of NOT ending the code with:
Application.ScreenUpdating=True

Are there any ill effects/problems that can result by not finishing out the macro by turning screen updating back on?

Thanks for your time.
Jase.
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,510
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
No, not really. It will reset when the code ends anyway.
 

jase71ds

Board Regular
Joined
Oct 23, 2006
Messages
104
Thanks!
I hadn't noticed any ill effects, but then thought it better that I check with the experts.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,510
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Not putting it in has the addd benefit that if you call one routine from another, the called one won't affect screenupdating for the calling routine.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,143
Messages
5,527,072
Members
409,743
Latest member
sukuto20

This Week's Hot Topics

Top