Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Q) Referencing the last cell in a formula

1 view
Skip to first unread message

Generic Usenet Account

unread,
Nov 13, 2008, 5:27:22 PM11/13/08
to
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

0 new messages