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

With Sheets (SheetName)
.Range ("A100").End (xlUp).Select
End with
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