CurrentArray Property [Excel 2003 VBA Language Reference]

  • Article

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

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.

ActiveCell.CurrentArray.Select

Applies to | Range Collection

See Also | CurrentRegion Property | HasArray Property