LastColumnLetter
(7.3)
Returns the letter value of the last column of a range.
Usage
@LColL([<Address>], [<AdjustBy>])
| Argument Name |
Description |
| Address |
If an address is not specified the last-used column on the sheet is returned. |
| AdjustBy |
If specified, will be added to the result. A negative value can be used. Integer. Optional. |
Examples
@LastColumnLetter
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 |
@LColL() |
|
|
A |
B |
C |
D |
| 1 |
|
January |
February |
March |
| 2 |
1000.0 |
D |
D |
D |
| 3 |
1001.0 |
D |
D |
D |
| 4 |
1002.0 |
D |
D |
D |