Range.CurrentArray Property
| Excel Developer Reference |
If the specified cell is part of an array, returns a Range object that represents the entire array. Read-only.
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 |
|---|
|
See Also