title: Excel VBA swapping columns of a vba range without a loop
body: <p>I have a range consisting of two columns that the user would define thru <code>Application.Inputbox</code> method. I would store that as <code>rng</code> in the VBA to be copied then pasted later to some cells in Excel sheet. Before pasting, I would like to swap these two columns in rng. Is there a way to do that without a loop and without having to swap the actual original columns in the excel sheet?</p>
  
  <p>So what I mean is something like this:</p>
  
  <pre><code>rng_swapped.Columns(1).Value = rng.Columns(2).Value
  rng_swapped.Columns(2).Value = rng.Columns(1).Value
  
  rng = rng_swapped
  </code></pre>