CurrentArray Property 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