FirstColumnLetter
(7.3)
Returns the letter value of the first column of a range.
Usage
@FColL([<Address>], [<AdjustBy>])
Argument Name |
Description |
Address |
If an address is not specified the first-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
@FirstColumnLetter
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 |
@FColL() |
|
|
A |
B |
C |
D |
1 |
|
January |
February |
March |
2 |
1000.0 |
A |
A |
A |
3 |
1001.0 |
A |
A |
A |
4 |
1002.0 |
A |
A |
A |