Function to get Union of Ranges

[capson]

I can make a union of ranges

Please Login or Register  to view this content.

But I want a inputbox to show and select the header rows of the columns I need in the union I got this far
Thanks

Please Login or Register  to view this content.

[AlphaFrog]

Try something like this (if i understood your question correctly).

Please Login or Register  to view this content.

[TMS]

Think you'd need to do it like this:

Please Login or Register  to view this content.

Regards, TMS

[capson]

I was a little unclean (sorry about that) I was hoping not to have to know in advance how many Sections in the union there were in advance of running the sub just to be able to select it as needed

[AlphaFrog]

I was a little unclean (sorry about that) I was hoping not to have to know in advance how many Sections in the union there were in advance of running the sub just to be able to select it as needed

You're still a little unclean. I don't know what that means. Sorry.

[TMS]

Do you mean this:

Please Login or Register  to view this content.

Regards, TMS

[nilem]

maybe so

Please Login or Register  to view this content.

[capson]

Thanks you all

nilem solution was what I was after

again apologies about my lack of clarity in writing my question

[TMS]

You're welcome. Thanks for the rep.


No problem, glad you have a solution.

Regards, TMS