Preventing Macro Flash

[PCakes]

I have recorded a macro, how do I stop it from showing all the steps I have
taken and simply run the macro? Do I use DIM if sho what is the correct way
of doing so?

 

[Paul B]

PCakes,

Application.ScreenUpdating = False

'Your code

Application.ScreenUpdating = True
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[PCakes]

Thank you! I am trying to teach myself some Visual Basics, but time is not

 

[Paul B]

Your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003