Getting the row from a range

[skulkrinbait]

I have a loop thus:

----------

For Each sMainScreen In Range("C4:CA21")


Next sMainScreen

---------

I need to get the row number for each pass of the iteration, how can I
do that please?

Thanks for any help.

 

[Rick Rothstein \(MVP - VB\)]

I have a loop thus:

----------

For Each sMainScreen In Range("C4:CA21")


Next sMainScreen

Inside the loop, sMainScreen.Row will give you that. If you haven't done so,
I would recommend including this declaration statement in your procedure....

Dim sMainScreen As Range

Then VBA's intellisense would provide you with the available properties (as
memory joggers) to select from.

Rick