Union with Each Column joining more than required!

  • Hi,

    I'm a VBA newbie - please tell me how to improve my post.

    While trying to iterate over a series of columns and join them one at a time to another range using Union I find that the number of columns joined starts at one column, then two, then three and so on. How do I prevent this to just join on the first, then just the second, then just the third etc.?

    My code is:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!