title: Excel VBA -Copying a range of multiple rows to another sheet
body: <pre><code>with Sheets("XYZ")    
  wSheet.Range("8:8,9:9,10:10,11:11,12:12,13:13,266:266,472:472").Copy
      .Cells(.Cells(.Cells.Rows.Count, 1).End(xlUp).Row + 1, 1).Select
      .Paste
  </code></pre>
  
  <p>Why does it not work and give me all the rows from 8 to 472 instead?
  I need specific rows, not all.</p>