PivotCell.Range Property

Syntax

expression.Range

expression A variable that represents a PivotCell object.

Example

The following example stores in a variable the address for the AutoFilter applied to the Crew worksheet.

rAddress = Worksheets("Crew").AutoFilter.Range.Address

This example scrolls through the workbook window until the hyperlink range is in the upper-left corner of the active window.

Workbooks(1).Activate Set hr = ActiveSheet.Hyperlinks(1).Range ActiveWindow.ScrollRow = hr.Row ActiveWindow.ScrollColumn = hr.Column

See also:

• PivotCell Object
• PivotCell Object Members