View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Return the row numbers or a dynamic range in VBA

Jim,

The first row:
MsgBox Range("Range_6").Row

The last row:
MsgBox Range("Range_6").Cells(Range("Range_6").Cells.Coun t).Row

HTH,
Bernie
MS Excel MVP


"Jim" <. wrote in message ...
Hello, I have finally figured out how to create a dynamic range and it works great.
Now I need to query this dynamic range to determine the row numbers of the first and last rows of
the range.

Example:

I have a dynamic range named Range_6. Being dynamic in nature, this range changes frequently.
What I need to know is how can I query this "Range_6" range to retrieve only its beginning row
number and ending row number?

If I have a dynamic range that equates to D11:D142 - using VBA, how can I query Range_6 to get
just the 11 and 142 part? I don't need to select the range "Range(range_6).Select", just return
the row numbers?

Hope that makes sense!!

Thanks
Jim