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