Find last row of named range using VBA (Excel 2000)

Topic

New Reply

Is there a way to determine via code what is the last row included in a named range, regardless of whether there is data in the last row or not? For example, if I have a sheet with a named range “Section1” that is defined as A1:C10, how can I determine that the last row is row 10? Even better, that the bottom left corner is cell A10? Perhaps I’m missing something obvious, but I’m not finding an easy way to do this.

Thanks!

Reply | Quote

Replies

Sure:


Dim lRow As Long
lRow = Range("MyRange").Cells(1, 1).Row + Range("MyRange").Rows.Count - 1


Reply | Quote

The following expression returns a reference to the bottom left corner of Section1 (assuming it consists of a single contiguous area):

Range(“Section1”).Cells(Range(“Section1”).Rows.Count,1)

To retrieve the address of this cell:

Range(“Section1”).Cells(Range(“Section1”).Rows.Count,1).Address

Reply | Quote

Beautiful, that’s just what I need. Hans and Legare, thanks to you both.

Reply | Quote