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

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

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