title: VBA paste to visible cells only
body: <p>I have range of cells on Sheet2 <code>F2:F41</code>, which I want to paste into visible cells in Sheet1. Visible cells on Sheet1 are in Range <code>M111:M643</code>. My Problem is, Excel pastes it to another cells as I want. </p>
  
  <p>Snippet for it: </p>
  
  <p>Do I miss loop or something like this? </p>
  
  <pre><code>Sheets("Tabelle2").Select 
  Dim tgt As Worksheet
  Set tgt = ThisWorkbook.Sheets("Tabelle1") 
  Dim from As Range 
  Dim destination As Range 
  Set from = Sheets("Tabelle2").Range("F2:F41") Selection.Copy   
  Set destination = Sheets("Tabelle1").Range("M11:M643").SpecialCells(xlCellTypeVisible) from.Copy Destination:=Sheets("Tabelle1").Range("M111")
  </code></pre>