Applies To
Range Object.
Description
Accessor. If the specified cell is part of an array, returns a Range object that represents the entire array. Read-only.
See Also
CurrentRegion Property, HasArray Property.
Example
This example assumes that the active cell is A1 on Sheet1 and that the active cell is part of an array that includes cells A1:A10. The example selects cells A1:A10 on Sheet1.
ActiveCell.CurrentArray.Select