Show Method

Microsoft Office Web Components Object Model

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