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 |