Merging cells with VBA <p>I'm looking to merge 3 horizontal cells, but i am doing so in a loop. The code looks something like this: </p> <pre><code>myrange.Range(cells(3,i), cells(3,i+3)).mergecells = true </code></pre> <p>This is not working. I'm guessing its because the code is trying to merge 2 cells that are not adjacent to each other. What is the syntax for merging a range of cells using this cell-address type?</p> <p>Any help would be greatly appreciated! thanks! </p>