title: Pasting merged cells using VBA
body: <p>I'm trying to copy a row of data from an excel sheet and transfer that to another sheet, but the range of row data has a two column merged cell in it and I'm having trouble pasting without any errors. </p>
  
  <p>Any tips would be very helpful,</p>