Thread: Ref of First Non blank cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sampoerna Sampoerna is offline
external usenet poster
  
Posts: 17
Default Ref of First Non blank cell
I need a formula to recognize the first non blank cell within an area e.g.
"B2:Z2", and the formula should displayed as address. My appreciation for
any help.

Reply With QuoteReply With Quote