This documentation is archived and is not being maintained.

Show Method

Office 2003

Scrolls the spreadsheet window to move the specified range into view.


expression    An expression that returns a Range object.


If you specify a range that is not on the active worksheet, this method will not activate that worksheet. However, the specified range will be visible when you activate that worksheet. For example, if Sheet1 is currently active and you use this method with cell A500 on Sheet2, Sheet1 remains active. Cell A500 will be active if you immediately activate Sheet2, either manually or by using the Activate method of the Worksheet object.


This example scrolls the spreadsheet until cell P75 is visible.


Applies to | Range Object