Copy Union Range with VBA

**esbencito** · 07-06-2018, 02:00 AM

Hi all,

I want to copy the dynamic Range ("A6:C6+b,F6:BS6+b") with code.

Please Login or Register  to view this content.

There's seems to be a syntax/with variable error...

Can someone help?

**Norie** · 07-06-2018, 02:20 AM

Have you tried using Union?

Please Login or Register  to view this content.

**Sintek** · 07-06-2018, 02:24 AM

See Norie assisted...

Please Login or Register  to view this content.

**esbencito** · 07-06-2018, 02:26 AM

Originally Posted by Norie

Have you tried using Union?

Please Login or Register  to view this content.

Now it says: Error 1004. This action won't work on multiple selections.

**Sintek** · 07-06-2018, 02:39 AM

Or ... If you don't want to use Post3 suggestion then...

Please Login or Register  to view this content.

**esbencito** · 07-06-2018, 02:41 AM

Originally Posted by sintek

Or ... If you don't want to use Post3 suggestion then...

Please Login or Register  to view this content.

Both your solutions seem to work! Thanks

**Sintek** · 07-06-2018, 02:46 AM

..........................................
Thanks.gif

Re: Copy Union Range with VBA