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
array area for active cell current current array Current Array Property Current cell in array? currentarray currentarray property Find out if cell is part of array.

See also: