title: Copying and pasting visible cells only
body: <p>I need to copy a column of visible cells and paste to the next column over.</p>
  
  <p>I can't find a macro that works. I had one going, but it only copies some numbers. </p>
  
  <p>Here is the code</p>
  
  <pre><code>Sub TryMe()
  Sheet1.Range("A1:A100").SpecialCells(xlCellTypeVisible).Copy _
    Destination:=Range("A1").Offset(ColumnOffset:=1)
  End Sub
  </code></pre>
  
  <p>This image is before I run the macro. Notice the rows that are hidden. I need these numbers to copy to the next column.<br>
  <a href="https://i.stack.imgur.com/Sz55d.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Sz55d.png" alt="enter image description here"></a></p>
  
  <p>This image is after I run the macro. I don't understand why only some of the numbers are copying. The hidden rows contain the numbers 3 and 6. Why are they in the outcome, but not the visible numbers? I need to copy what is seen.<br>
  <a href="https://i.stack.imgur.com/QRsJG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QRsJG.png" alt="enter image description here"></a></p>