For Each cell In Target.Entirerow
x= ...cell.value
Next



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Paulymon" wrote in message
...
I have a a spreadsheet that has filters on it. I want to be able to
itterate
through a range that is selected using the worksheet's change event.
The target range might be $e200,$e300,$e500:$e510

I want to be able to do something like

for each row in target.range
x= ...cell(1,row#).value
next

So I would run through the loop for row 200, row 300, and rows 500-510

Any advice on how to accomplish this would be appreciated.