title: how to paste entire column in excel vba without selecting the sheet
body: <p>I'm trying to copy the first column into the last column.  What's wrong with this code?  Getting the following error:</p>
  
  <pre><code>Run-time error '438
  object doesn't support this property or method
  </code></pre>
  
  <p>Does vba allow <code>Copy</code> but not <code>paste</code> for columns?</p>
  
  <pre><code>Sub copy_ids_user_output(sheet_name As String)
  
  '   find last column
      Dim last_col As Integer
      last_col = Worksheets(sheet_name).Cells(1, Columns.Count).End(xlToLeft).column
      Debug.Print last_col
  
      Columns(1).Copy
      Columns(last_col + 1).Paste
  
  
  End Sub
  </code></pre>