title: Using VBA to select non-adjacent range
body: <p>I know how to select a range till a calculated last row using vba as such:</p>
  
  <pre><code>Range("P3:R" &amp; LastRow).Select
  </code></pre>
  
  <p>Is there a way to select non-adjacent column data? For example I want cells from column N to R <strong>WITHOUT</strong> column O</p>
  
  <p>Tried below, but it ends up selecting O too, I suspect because the <code>"</code> character should encompass the whole thing, but then how do I keep the variable value for last row?</p>
  
  <pre><code>Range("N3:N" &amp; LastRow , "P3:R" &amp; LastRow).Select
  </code></pre>
  
  <p>Thanks!</p>