Q) Referencing the last cell in a formula

[Generic Usenet Account]

Hi,

I would like to know if there is a generic way to reference the last
non-blank cell in an Excel formula. The last non-blank cell could
be:
1) in a row (e.g. $LASTROW)
2) in a column (e.g. $LASTCOL)
3) in a worksheet


Thanks,
Gus

 

[Gary''s Student]

You say "reference"

Do you want the value of this last cell or its location?