Selecting a range on a non-active sheet

[Newbie_Nick]

I'm using Excel 2003 and when I activate a sheet before selecting a certain range the screen inevitably flickers (especially when I have multiple ranges on different sheets).

Since I want to avoid this, is there any way to select a range without activating the sheet, on which it is located.

I tried

Please Login or Register  to view this content.

but that didn't work.
Alternatively, is there any way to disable that flickering (ScreenUpdating = False didn't do the trick for me).

Thanks
Nick

[teylyn]

Nick, the complete line should be

Please Login or Register  to view this content.

When that is engaged, you should not see anything happening on the screen untill the updating is set to True again.

Why do you need to select the range in the first place? There are often other ways to do things than with .Select

[Newbie_Nick]

Problem solved...I had misplaced the code that reactivates screen updating...sorry to bother you all.

Thanks anyway
Nick