Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Speed up Macro

Status
Not open for further replies.

rnordquest

New member
Joined
Jul 17, 2003
Messages
148
Location
US
What is the form of the command to stop the display from updating? This reduces the macro calculation time.

It's something like: WindowsUpdate = False
 
Application.ScreenUpdating = False
 
The precise answer I was looking for. When I change jobs and move to another company I can never seem to remember this.

Thanks,

Roger
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top