Home » Forums » Open Source Learning Center » Question and Answer

VBA loop to add cells to selection and merge

Submitted by MohammedTageldin on 2 March, 2015 - 21:40

Hi,
I am looking for a code to loop through cells and add them to the selection, in order to merge them all at end of loop.
Regards.

‹ help needed LOOP function VBA ›
»
Nick's picture

you can use the UNION

Submitted by Nick on 3 March, 2015 - 09:52.

you can use the UNION function in VBA to add ranges together...

here's an example of how it's used:

http://excelexperts.com/xla-routines-eerangeunion

»