Hi,

I am currently working on a macro that involves switching betwee
different worksheets many times. The worksheets are all named so tha
they can be accessed using several for loops. I have se
Application.ScreenUpdating to False, but the computer still visuall
switches between sheets, slowing down processing time. Is there any wa
to avoid this? Maybe it's because I activate each sheet as I use it so
can use ActiveSheet when I should instead just reference the shee
everytime I have ActiveSheet? Thanks in advance for your help.

-Rama

--
Raman32
-----------------------------------------------------------------------
Raman325's Profile: http://www.excelforum.com/member.php...fo&userid=2474
View this thread: http://www.excelforum.com/showthread.php?threadid=38363