Show Method
Scrolls the spreadsheet window to move the specified range into view.
expression.Show
*expression * An expression that returns a Range object.
Remarks
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.
Example
This example scrolls the spreadsheet until cell P75 is visible.
Spreadsheet1.ActiveSheet.Range("p75").Show
Applies to | Range Object
See Also | ScrollIntoView Method