Screen update!!!

[MarkReddell]

Is there a way to turn screen updating on & off 2 make the macros run faster??? I've tried 2 make this work & it works OK until I try 2 enable the screen update again I get a debug error!!! Thanx 4 anyones help!!! God Bless!!!

 

[hail11]

Application.ScreenUpdating = False
'code
Application.ScreenUpdating = True

 

[Nalani]

Is there a way to turn screen updating on & off 2 make the macros run faster??? I've tried 2 make this work & it works OK until I try 2 enable the screen update again I get a debug error!!! Thanx 4 anyones help!!! God Bless!!!

The Bolded part of your question brings up the question(s):
1. Where are you tryring to put ScreenUpdating = False/True in your code?
2. What is the error are you getting?

It would really help if you post the code for us to see. (Please use Code Tags when posting code, or press the # sign in the Reply box and paste your code between the bracket pairs.)

It may be that the slow down is caused by some other means like Select and Activate.

 

[MarkReddell]

thx 4 the help Hail11 & Nalani !!! Its worx fine!!! Happy Thanksgiving & Merry Christmas !!!!!!!!