excel vba range property non contiguous range

[Ramo13541]

Hi everybody,

I just want to fill different non contiguous ranges from an original cell containing

Please Login or Register  to view this content.

. Here's the code (wich doesn't work, just to get the idea clearer):

Please Login or Register  to view this content.

i don't know the correct synthax.
Thanks for your help

[Trebor76]

Hi Ramo13541,

This will copy the contents of cell E5 (which could be a formula) to cells K5, O5 and Q5:

Please Login or Register  to view this content.

Does that help?

Robert

[Ramo13541]

Hi Trebor76 , thanks for your answer. can i copy to non contiguous ranges instead of non contiguous cells ?

[Trebor76]

Do you mean like this:

can i copy to non contiguous ranges instead of non contiguous cells ?

Please Login or Register  to view this content.