VBA loop to add cells to selection and merge

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.

Nick's picture

you can use the UNION

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

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