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.