I think that should be

Dim rw As Range

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Norman Jones" wrote in message
...
Hi Nir20,

Dim rw As Long

For Each rw In Selection.Rows
'Processing code
Next rw


---
Regards,
Norman



"nir020" wrote in message
...
How can I declare a variable and then assign to a row so that it can be
used
in a for loop?

Thanks