Thread: Last Row In Named Range
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Sprinks Sprinks is offline
external usenet poster
  
Posts: 86
Default Last Row In Named Range
JLGWhiz,

Thanks.

"JLGWhiz" wrote:

Try this
lastRow = Cells(Rows.Count, NamedRange.Columns(1)).End(xlUp).Row

"Sprinks" wrote:

Can someone tell me how to return the last row in a named range?

Thank you.
Sprinks
Reply With QuoteReply With Quote