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