r.Rows.Count will return the number of rows in the range.


--
Dick Kusleika
MS MVP - Excel
www.dailydoseofexcel.com

TechWrangler wrote:
Thanks for the quick response. I want to use this as my loop control
variable so I can loop through a varible size range and copy the
elements to another Worksheet. So it doesn't need to print. Would I
still use this?

Or would I do something like:

set r = Range ("CRP01")
Dim i = r.????
Dim crpCount = 2

For crpRow = crpCount To i
Code...
Next crpRow