I'm trying to merge multiple selections in Excel via VB/Macro.
Meaning that I want to perform multiple selections at once, and then merge those selections, not all into one, but into individual merges.
This is easily done manually, using Ctrl + click + drag I can perform multiple selections, and when I click the Merge button, each Selection becomes merged.
But when I do it on a Macro, it takes the top-left cell and the bottom-right cell of all selections, and turns it into a single, big selection.
I'm also using R1C1 terminology throughout the whole program, so I'm not working with column letters.
This is an example with two separate ranges, that becomes a single range when executed.
Range(Cells(1, 1), Cells(1, 3)), _
Range(Cells(1, 4), Cells(1, 15)) _
Do you have any ideas? Thank you in advance for reading.