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" wrote in message
...
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?