title: Merge cells in Excel
body: <p>I am working on generating excel report using vba code. I am new in this. Just wanted to know if i need to merge any particular range of columns/cells but not sure from where they start but always ends up after 5 cells.</p>
  
  <p>Below is my code:</p>
  
  <pre><code>ShtReport.Cells(7, col + 1).Value = RS("Fund")
  </code></pre>
  
  <p>from above line, value is being set in 7th row and let say col value is 6 then above line will set the value in 7th row 7th column. But what i need that it should merge cells from 7th to 12th along with its text.</p>
  
  <p>Please help me solving this.</p>