In Excel 2000 - I don't see the sheet changes.

But you can avoid all selecting and activating in your code. This makes it
even faster.

Sheets("MySheet").Range("$A$1:$E$25").Copy _
Destination:=Sheets("YourSheet").Range ($T$12)

Sheets("YourSheet").Range ($T$12)= Sheets("MySheet").Range($F$33)

steveB

Remove "AYN" from email to respond
"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