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.

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.

I would like to not have to step through each cell in the selection. I've
used the for each cell statement before for other purposes. I would like a
for each row in selection type response. Thanks for your input.

"Bob Phillips" wrote:

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.

What do you want to do with each row, and will whole rows be selected or
just cells?

--
HTH

Bob Phillips

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

"Paulymon" wrote in message
...
I would like to not have to step through each cell in the selection. I've
used the for each cell statement before for other purposes. I would like
a
for each row in selection type response. Thanks for your input.

"Bob Phillips" wrote:

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.