Application.Rows

[kittronald]

How can you use "Application.Rows" to calculate the number of rows in
the range below ?

The defined name "Test" refers to Sheet1!$A$1:$A$2

Set src = Workbooks("Book1.xlsb").Names("Test").RefersToRange


kittronald

 

[Jim Cone]

How about you don't and instead use: src.Rows.Count
--
Jim Cone
Portland, Oregon USA
http://blog.contextures.com/archives/2011/07/18/find-last-row-with-excel-vba/





"kittronald" <[email protected]>
wrote in message
news:[email protected]...

 

[kittronald]

Jim,

That'll do it !

Thanks.


kittronald