title: Excel macro to move column
body: <p>Basically I'm looking to move a column for one position to another.</p>
  
  <pre><code>561  DISK_GROUP_003 0   545     1
  561  Disk_Group_iS  95  84144   80210
  561  DISK_GROUP_iS  99  26335   26304
  1415    t1_200ea    93  8804    8203
  1415    t2_30010k   35  59846   21121
  1415    t3_1tb72k   19  184941  36590
  1415    t3_3tb72k   86  258635  224328
  5018    t1_200ea    98  9905    9802
  5018    t2_30015k   89  39987   35986
  5018    t2_60015k   67  59984   40700
  5018    t3_1tb72k   89  87567   78807
  5018    t3_2tb72k   84  94412   79620
  </code></pre>
  
  <p>I need to move the 3rd column to the end at the right.</p>
  
  <p>This is what I have tried so far:</p>
  
  <pre><code>Sub moveColumn()
  
  With ActiveSheet        
          Excel.Columns(3).Cut
          Excel.Columns(6).PasteSpecial
  End With
  
  End Sub
  </code></pre>
  
  <p>But this method doesn't work as it gets a runtime error '1004'.</p>
  
  <p>Any help would be much appreciated.</p>