title: Variable for Excel Columns. Column Assigned to Variable
body: <p>I have a macro that inserts 2 columns on my current sheet and pastes information from another sheet.</p>
  
  <p>I want to create 2 variables that are assigned to each column that would change the next time I run the macro to paste the information in the next two columns.</p>
  
  <pre><code>Columns("BO:BO").Select
  
  Selection.Insert Shift:=xlToRight
  
  Range("BO2").Select
  ActiveCell.FormulaR1C1 = "Feb weekly-wk 2"
  Range("BO19").Select
  ActiveCell.FormulaR1C1 = _
      "=VLOOKUP(Comparison!RC2,'Jan16 wk4'!R3C15:R34C24,9,FALSE)"
  Range("BO19").Select
  Selection.AutoFill Destination:=Range("BO19:BO47"), Type:=xlFillDefault
  Range("BO19:BO47").Select
  
  Columns("BP:BP").Select
  
  Selection.Insert Shift:=xlToRight
  Range("BP2").Select
  Selection.Style = "20% - Accent6"
  Range("BP2").Select
  ActiveCell.FormulaR1C1 = "Diff"
  Range("BP19").Select
  ActiveCell.FormulaR1C1 = "=RC[-2]-RC[-1]"
  </code></pre>
  
  <p>My idea is to set up a variable that I would replace my current "BO" and "BP" code with. </p>
  
  <pre><code>Dim X as String, Y as String
  
  X = "BO"
  
  y = "BP"
  </code></pre>
  
  <p>When I run the macro it would change the variable for this example "BO" to "BQ" and "BP" to "BR". Next time I run the macro would change the "BQ" to "BS" and "BR" to "BT".</p>