03-22-2003, 07:45 AM
|
 |
Variable not defined
Retired Moderator
* Guru *
|
|
Join Date: Apr 2002
Location: Ottawa, Ontario
Posts: 4,793
|
|
Quote:
|
Originally Posted by Jdo300
I'm just curious. Is there any kind of property of a spreadsheet that you can set to stop it from updating formatting changes? I have macros that Run lengthy formatting operations, and although I used Range objects to manipulate the cells the program can run slow because it always wants to refresh after every single change... So can I temporarily stop it from doing this while my macro is running?
|
Use Application.ScreenUpdating=False at the beginning of your macro
And Application.ScreenUpdating=True at the end of your macro.
You'll notice an increase in speed. Typically, during testing I don't use the ScreenUpdating property just so I can see exactly what is happening. |
__________________
-Carl
|
Excel Macro question
Hybrid Mode
