title: Copy values from one worksheet to another
body: <p>How can I copy some data from one worksheet to another?</p>
  
  <p>I tried this code, but get an error:</p>
  
  <pre><code>Private Sub CommandButton2_Click()
      Sheets("Gas Opt").Select
      Range("A1:A3").Select
      Selection.Copy
  
      Sheets("ExportToPPServer").Select
      Cells(3, AColumn).Select
      Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
  
      LFound = True
      MsgBox "Data coped."
  
  
  End Sub
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code>Select method of Range class failed.
  </code></pre>