title: Using "cells" with "range"
body: <p>I have been searching for this for a while now and I have not been successful.</p>
  
  <p>I am trying to use range with cells command in VBA, and the last row is variable. Moreover, I am not getting consecutive columns.</p>
  
  <p>I have to select range <code>S2:S9</code> and <code>U2:U9</code> (as already said, last row can be variable). I know this command works:</p>
  
  <pre><code>Range(Cells(2, 19), Cells(NumberofRows, 19)).select
  </code></pre>
  
  <p>But I need to select 2 different columns that are not consecutive. I am trying something like this but no success:</p>
  
  <pre><code>Range(Cells(2, 19), Cells(NumLinhas, 19);(Cells(2, 21), Cells(NumLinhas, 21)).Select
  </code></pre>
  
  <p>Does anyone know how to do it?</p>