title: Create Range excluding column in middle
body: <p>I have the problem of needing to exclude a column in the middle of my excel worksheet. Is there a way of creating a range that excludes a column not on the edges of the data. The range is dynamic ranging from A1:AA#. The column "F" needs to be excluded from this range. This range needs to be stored for use in a pivotTable.</p>
  
  <pre><code>Range("A1:E4,G1:J4").Select
  </code></pre>
  
  <p>This is how the excel macro recorder creates a range with a gap, but I cannot find a way to modify this so the last cell is dynamic.</p>
  
  <p>Thanks.</p>