title: Select method of Range class failed via VBA
body: <p>This is the code that I'm currently working with, and I'm getting this problem. I'm novice at Excel and I can't figure out what's wrong.</p>
  
  <pre><code>Private Sub cmdRecord_Click()
  Sheets("BxWsn Simulation").Range("Result").Select //This is the line with the problem, as excel told me.
      Selection.Copy
      Sheets("Reslt Record").Select
      Sheets("Reslt Record").Range("A5000").End(xlUp).Offset(1).Select
      Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
          xlNone, SkipBlanks:=False, Transpose:=False
      Sheets("CuCon Simulator").Select
      Application.CutCopyMode = False
      Range("Improvement").Select
  End Sub
  </code></pre>
  
  <p>The error is <code>Select method of Range class failed via VBA, Error 1004</code>.
  Any ideas?</p>
  
  <p><strong>ETA:</strong></p>
  
  <p>So I just changed the code to </p>
  
  <pre><code>Sheets("BxWsn Simulation").Select
  Range("Result").Select
  </code></pre>
  
  <p>I believe this is what you mean by making it active?</p>
  
  <p>However I'm still getting <code>Method 'Range' of object '_Worksheet' failed, error 1004</code>.</p>