title: How to solve Runtime Error 1004; we cant do that in a merged cell
body: <p>every time theres only one column with data in Sheet1 and I run the code below it's giving me this error message.</p>
  
  <blockquote>
    <p>Runtime Error 1004; we can't do that in a merged cell    </p>
  </blockquote>
  
  <pre><code>Sheets("Sheet1").Select
  Range("E6", "G6:I6").Select
  Range(Selection, Selection.End(xlDown)).Select
  Selection.SpecialCells(xlCellTypeVisible).Copy
  Windows("Excel.xlsm").Activate
  Sheets("Sheet1").Select
  Range("A" &amp; Rows.Count).End(xlUp).Offset(1).Select
  ActiveSheet.Paste
  </code></pre>