CellsAddress
Returns the address of the range of all the cells on the current worksheet.
Usage
@CellsAddress()
| Argument Name |
Description |
| This function does not take any arguments |
Examples
@CellsAddress
function example
|
A |
B |
C |
D |
| 1 |
|
January |
February |
March |
| 2 |
1000.0 |
| 3 |
1001.0 |
| 4 |
1002.0 |
| Procedure |
|
| |
Method |
Overload |
ErrorHandlingMode |
|
| |
|
Argument |
Value |
Comment |
| OnAfterBuild |
|
| |
SetEntry
|
Text
|
|
|
| |
|
Address |
Data.Range |
|
| |
|
CellByCell |
True |
|
| |
|
CellCondition |
|
|
| |
|
Entry |
@CellsAddress() |
|
|
A |
B |
C |
D |
| 1 |
|
January |
February |
March |
| 2 |
1000.0 |
$1:$1048576 |
$1:$1048576 |
$1:$1048576 |
| 3 |
1001.0 |
$1:$1048576 |
$1:$1048576 |
$1:$1048576 |
| 4 |
1002.0 |
$1:$1048576 |
$1:$1048576 |
$1:$1048576 |