Merge cells in range
Posted on 2012-04-01
I thought I knew what I was doing - but NO. I am trying to merge cells quickly.
On my sheet I have Range("K7:BA7") that I need to merge. (K7&L7, then M7&N7 etc.)
Here is my code:
Dim i As Long
For i = 11 To 45 Step 2
Sheet7.range(cells(7, i), cells(7, i + 1)).merge
However I am getting an error code 1004 - I do not know what I am doing wrong.
Can you please correct me which will educate me, as well.