Screen Updating

[Raman325]

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

[Doug Glancy]

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" <[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
>

[STEVE BELL]

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
>