I'm doing some detective work on a spreadsheet and I've run across this named formula using what is I think a now unsupported syntax for the address function
LastActiveCell =ADDRESS(LastRowInLedger,47)
Has anyone seen this in action before? Any references you can point me at?
TIA
LastRowInLedger
-
- Administrator
- Posts: 78596
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: LastRowInLedger
The ADDRESS function has syntax
=ADDRESS(row_num, col_num, [abs_num], [a1], [sheet])
Arguments in square brackets are optional.
Example: =ADDRESS(3, 5) returns $E$3: the address of the cell in row 3, column 5.
In your example, LastRowInLedge is another defined name that returns a row number.
The value of LastActiveCell will be the address of the cell in row LastRowInLedge, column 47 (i.e. column AU).
See ADDRESS function
=ADDRESS(row_num, col_num, [abs_num], [a1], [sheet])
Arguments in square brackets are optional.
Example: =ADDRESS(3, 5) returns $E$3: the address of the cell in row 3, column 5.
In your example, LastRowInLedge is another defined name that returns a row number.
The value of LastActiveCell will be the address of the cell in row LastRowInLedge, column 47 (i.e. column AU).
See ADDRESS function
Best wishes,
Hans
Hans
-
- StarLounger
- Posts: 58
- Joined: 26 Jan 2010, 18:21
Re: LastRowInLedger
Hi Hans
thanks for this -So I can only assume that LastRowInLedger came along as some copy/paste artifact without actually copying the named cell "LastRowInLedger". I'm doing something different with the information now, so I don't need to dig any deeper. I was just wondering if this was old syntax that might bite me if I work in another old spreadsheet. Since your memory banks say no - I feel confident I don't need to worry about it.
Thanks!
thanks for this -So I can only assume that LastRowInLedger came along as some copy/paste artifact without actually copying the named cell "LastRowInLedger". I'm doing something different with the information now, so I don't need to dig any deeper. I was just wondering if this was old syntax that might bite me if I work in another old spreadsheet. Since your memory banks say no - I feel confident I don't need to worry about it.
Thanks!