title: Run Time Error '1004': Select method of Range Class failed VBA 2003
body: <p>I am trying to copy a column from one sheet to another. The code I am using is a recorded macro and it works fine until I connect it to a button.  When I do so, it gives a</p>
  
  <blockquote>
    <p>Run Time Error '1004': Select method of Range Class failed</p>
  </blockquote>
  
  <p>Here is the code and I can see nothing wrong with it. When I hit debug it highlights the second line.</p>
  
  <pre><code>Sheets("Count").Select
  Columns("C:C").Select
  Selection.Copy
  Sheets("Add Invintory").Select
  Range("b1").Select
  ActiveSheet.Paste
  Sheets("Count").Select
  Sheets("Count").Columns("A:A").Select
  Columns("A:A").Select
  Selection.Copy
  Sheets("Add Invintory").Select
  Range("A1").Select
  ActiveSheet.Paste
  </code></pre>
  
  <p>I have no clue what the problem is.  Please help</p>