Export (0) Print
Expand All
Expand Minimize

Range.CurrentArray Property

Office 2007
If the specified cell is part of an array, returns a Range object that represents the entire array. Read-only.

Syntax

expression.CurrentArray

expression   A variable that represents a Range object.

Example

This example assumes that cell A1 on Sheet1 is the active cell and that the active cell is part of an array that includes cells A1:A10. The example selects cells A1:A10 on Sheet1.

Visual Basic for Applications
ActiveCell.CurrentArray.Select



Community Additions

ADD
Show:
© 2014 Microsoft