Help - loop through cells in a range that are not together (several different cells as Target)

[Marie J-son]

Hi,

I'm stuck. I need to loop through each cell with my code and get range
error. I belive it is because the range consist of cells that are not
together.Right?

Actually, the event is when you copy one cell and select a number of others
and paste - dadaam, all cells have the same value as the copied cell. I use
Worksheet_change event and now I need to run some code with each cell in
Target.

How to do that?

/Kind regards

[Leith Ross]

Hello Marie,

Could you post your code or an example of what your problem is and what you would like to happen. It isn't clear from this post what is happening with your code.

Thanks,
Leith Ross

[K Dales]

Can't really tell what is going wrong without seeing your code. but here is a
way to loop through the target range cell by cell, even if the cells are
non-adjacent:

Dim K As Range

MsgBox Target.Address ' shows the address that Target itself is set to

For Each K In Target.Cells
MsgBox K.Address ' shows that now K is one of the individual cells in
Target
Next K


"Marie J-son" wrote:

> Hi,
>
> I'm stuck. I need to loop through each cell with my code and get range
> error. I belive it is because the range consist of cells that are not
> together.Right?
>
> Actually, the event is when you copy one cell and select a number of others
> and paste - dadaam, all cells have the same value as the copied cell. I use
> Worksheet_change event and now I need to run some code with each cell in
> Target.
>
> How to do that?
>
> /Kind regards
>
>
>

[Tom Ogilvy]

for each cell in Target

Next

--
Regards,
Tom Ogilvy

"Marie J-son" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I'm stuck. I need to loop through each cell with my code and get range
> error. I belive it is because the range consist of cells that are not
> together.Right?
>
> Actually, the event is when you copy one cell and select a number of
others
> and paste - dadaam, all cells have the same value as the copied cell. I
use
> Worksheet_change event and now I need to run some code with each cell in
> Target.
>
> How to do that?
>
> /Kind regards
>
>

[Marie J-son]

Thank you Dale,

/Regards


"K Dales" <[email protected]> skrev i meddelandet
news:[email protected]...
> Can't really tell what is going wrong without seeing your code. but here
> is a
> way to loop through the target range cell by cell, even if the cells are
> non-adjacent:
>
> Dim K As Range
>
> MsgBox Target.Address ' shows the address that Target itself is set to
>
> For Each K In Target.Cells
> MsgBox K.Address ' shows that now K is one of the individual cells in
> Target
> Next K
>
>
> "Marie J-son" wrote:
>
>> Hi,
>>
>> I'm stuck. I need to loop through each cell with my code and get range
>> error. I belive it is because the range consist of cells that are not
>> together.Right?
>>
>> Actually, the event is when you copy one cell and select a number of
>> others
>> and paste - dadaam, all cells have the same value as the copied cell. I
>> use
>> Worksheet_change event and now I need to run some code with each cell in
>> Target.
>>
>> How to do that?
>>
>> /Kind regards
>>
>>
>>

[Marie J-son]

Damn you, Tom. Why does it look so easy for you...-)

Working all right, of course

Thanks you
/Regards

"Tom Ogilvy" <[email protected]> skrev i meddelandet
news:%[email protected]...
> for each cell in Target
>
> Next
>
> --
> Regards,
> Tom Ogilvy
>
> "Marie J-son" <[email protected]> wrote in message
> news:[email protected]...
>> Hi,
>>
>> I'm stuck. I need to loop through each cell with my code and get range
>> error. I belive it is because the range consist of cells that are not
>> together.Right?
>>
>> Actually, the event is when you copy one cell and select a number of
> others
>> and paste - dadaam, all cells have the same value as the copied cell. I
> use
>> Worksheet_change event and now I need to run some code with each cell in
>> Target.
>>
>> How to do that?
>>
>> /Kind regards
>>
>>
>
>