Export (0) Print
Expand All

Show Method

Office 2003

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



Show:
© 2014 Microsoft