Thread: Finding row # of last cell containing contents
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
  
Posts: 972
Default Finding row # of last cell containing contents
I have a 1-column (A) worksheet. Rows 1-5 may contain alphanumeric text or
be blank. Rows 6 thru ?? always contain alphanumeric text (i.e. no blank
cells). Starting with row 6, I need to determine the last row containing
alphanumeric text. I would prefer to use Excel's built-in functions rather
than a UDF.
Can anyone tell me how to do this?
Thanks,
Bob
Reply With QuoteReply With Quote