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