<div>
You are right - thanks for checking, so the points are yours. &nbsp;I was being stupid and did not have it in a module but was trying to initiate from another worksheet routine.<br />
<br />
I will remember next time. &nbsp;I knew this, I just forgot.
</div>


You are right - thanks for checking, so the points are yours.  I was being stupid and did not have it in a module but was trying to initiate from another worksheet routine.

I will remember next time.  I knew this, I just forgot.

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I thought I knew what I was doing - but NO. &nbsp;I am trying to merge cells quickly.<br />
On my sheet I have Range(&quot;K7:BA7&quot;) that I need to merge. (K7&amp;L7, then M7&amp;N7 etc.)<br />
<br />
Here is my code:<br />
<br />
&nbsp; &nbsp;Dim i As Long<br />
<br />
&nbsp; &nbsp;For i = 11 To 45 Step 2<br />
&nbsp; &nbsp;Sheet7.range(cells(7, i), cells(7, i + 1)).merge<br />
&nbsp; &nbsp;Next i<br />
<br />
However I am getting an error code 1004 - I do not know what I am doing wrong.<br />
<br />
Can you please correct me which will educate me, as well.<br />
<br />
Thank you!
</div>
</div>


Hello Experts,

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
   Next i

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.

Thank you!

Merge cells in range

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.