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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>