title: VBA - How to set the start and end row when setting a range by column numbers
body: <p>Suppose I set a range of multiple distinct columns by column number like this:</p>
  
  <pre><code>Set rngData = shtData.Range(Columns(1), Columns(2), Columns(5))
  </code></pre>
  
  <p>But I only want the range to start at for example row 5 and end at row 10.</p>
  
  <p>Can I specify this in the Set rngData statement? Appreciate any help </p>
  
  <p>EDIT.</p>
  
  <p>Thanks to KazJaw this is the solution that worked for me:</p>
  
  <pre><code>    Dim shtData, rngData
      Set shtData = Worksheets("Data")
      Set rngData = Union(shtData.Columns(1), shtData.Columns(2), shtData.Columns(5))
      Set rngData = Intersect(rngData, shtData.Rows("5:10"))
  </code></pre>