<div>
Thanks a million that did it.
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
I am creating a report in my access application and need to merge cells in the report the following code won't work the syntax is wrong help much appreciated. The output is dependant on the number of records so i must use nStock code to denote increment in records.<br />
The original code <br />
&nbsp;wsOrder.Range(&quot;c&quot; &amp;&nbsp;nStkCode).value = recEquipment.Fields(&quot;Descr<wbr />iption&quot;) is not suitable as the record overflows. I tried this to merge the cells but getting error.<br />
<br />
wsOrder.Range(&quot;C&quot;&amp; nStkCode &quot;: E&quot;&amp; nStkCode).MergeCells = True<br />
Thanks<br />
mbsparrow
</div>
</div>


Hi
I am creating a report in my access application and need to merge cells in the report the following code won't work the syntax is wrong help much appreciated. The output is dependant on the number of records so i must use nStock code to denote increment in records.
The original code 
 wsOrder.Range("c" & nStkCode).value = recEquipment.Fields("Description") is not suitable as the record overflows. I tried this to merge the cells but getting error.

wsOrder.Range("C"& nStkCode ": E"& nStkCode).MergeCells = True
Thanks
mbsparrow

Merging cells in excel report in VB/MSaccess

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.