Excel Macro question

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?

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.