expression.CurrentArray
expression Required. An expression that returns a Range object.
Remarks
Use the HasArray property to determine whether or not a cell is part of an array.
Example
Assuming that the active cell is part of an array, this example selects the array.
Spreadsheet1.ActiveCell.CurrentArray.Select