Hi Dave,

To get the row number of the current active cell,

ActiveCell.Row

If myCell is a range variable that you use to loop through each cell in a
certain range, then myCell.Row should work.. For example:

Dim myCell as Range
For each myCell in Range("A1:A10")
Debug.Print myCell.Row
Next myCell


--
Hope that helps.

Vergel Adriano


"Dave Birley" wrote:

I was expecting myCell.Row to return the current Row number as an integer
when I loop through a series of rows in a Range. It appears to think that "1"
is all I will ever need to know <g!

What is the correct way to ask for the current Row number?
--
Dave
Temping with Staffmark
in Rock Hill, SC