View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David David is offline
external usenet poster
 
Posts: 1,560
Default Last Row Number in a Named Range

I have 3 Named Ranges that change as data is added. Unfortunately, they are
all in Column A.
I need a function that will tell me the row number of the last row with data
in the named range. If I can get one to work, I can do the other two.
One of the range names is MSE and is currently A2:A31. In this example, I'm
looking for a function that will return 31.
Thanks!