snowmantle
Programmer
Hi,
I am using Application.Union to combine several 1 column ranges together.
However I want to be able to order them in order the arguments are supplied to the method and not in the original order the columns were in. Is this possible?
Example:
Col1, Col2, Col3, Col4, Col5, Col6, Col7, Col8, Col9, Col10
Application.Union(Col1, Col7, Col5, Col3, Col10)
And the result of the union is put in a new sheet with the cols in this order
Col1, Col7, Col5, Col3, Col10
I know I could just do it some other way but the existing code already uses this union and I do not have much time.
I welcome other suggestions if this just is not going to be possible using the union method.
Thanks
I am using Application.Union to combine several 1 column ranges together.
However I want to be able to order them in order the arguments are supplied to the method and not in the original order the columns were in. Is this possible?
Example:
Col1, Col2, Col3, Col4, Col5, Col6, Col7, Col8, Col9, Col10
Application.Union(Col1, Col7, Col5, Col3, Col10)
And the result of the union is put in a new sheet with the cols in this order
Col1, Col7, Col5, Col3, Col10
I know I could just do it some other way but the existing code already uses this union and I do not have much time.
I welcome other suggestions if this just is not going to be possible using the union method.
Thanks