Raman,

I don't actually know whether activating sheets would cause the behavior you
describe, but you are absolutely right that you should alter your code to
eliminate the Activates where possible.

hth,

Doug

"Raman325" wrote in
message ...

Hi,

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

-Raman


--
Raman325
------------------------------------------------------------------------
Raman325's Profile:
http://www.excelforum.com/member.php...o&userid=24748
View this thread: http://www.excelforum.com/showthread...hreadid=383639