View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default Cell Address, Last Non Empty Cell


Range("A" & rows.count).end(xlup)

--
Regards,
Fred


"Filo" wrote in message
...
How can I retrieve the address of the last non empty cell in column A,
starting from the bottom of column A?

Thank you!