title: Copying and Pasting a Range of Cells from One Worksheet to Another Worksheet
body: <p>I am trying to copy a range of cells from one worksheet (Sheet2) to a different range of cells in another worksheet (Sheet1) but when I run the below, I get a run time error (1004) application defined or object defined error. Any help is appreciated!</p>
  
  <pre><code>Option Explicit
  
  Sub deletecolumns()
  
  Workbooks(1).Worksheets(1).Columns(2).Select
  Workbooks(1).Worksheets(1).Columns(2).Delete
  
  
  Sheets("Sheet2").Range("I4:I29").Copy Destination:=Sheets("Sheet1").Range("H4:H29")
  
  End Sub
  </code></pre>