Q) Referencing the last cell in a formula
 

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

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