Q) Referencing the last cell in a formula
You say "reference"
Do you want the value of this last cell or its location?
--
Gary''s Student - gsnu200813
"Generic Usenet Account" wrote:
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
|