View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,comp.sources.d
Generic Usenet Account Generic Usenet Account is offline
external usenet poster
 
Posts: 1
Default 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