Returns the index of the first column of a range.
@FCol([<Address>])
| Argument Name | Description |
|---|---|
| Address | If an address is not specified the first-used column on the sheet is returned. |
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 | @FCol(Data.Range) | |||||
| A | B | C | D | |
|---|---|---|---|---|
| 1 | January | February | March | |
| 2 | 1000.0 | 2.0 | 2.0 | 2.0 |
| 3 | 1001.0 | 2.0 | 2.0 | 2.0 |
| 4 | 1002.0 | 2.0 | 2.0 | 2.0 |