title: Excel: Named range with VBA
body: <p>I'm trying to define a named range in Excel using VBA.
  Basically, I have a variable column number. Then a loop runs to determine the first empty cell in that particular column.
  Now I want to define a named range from row 2 of that particular column to the last cell with data in that column (first empty cell - 1).</p>
  
  <p>For example, column 5 is specified, which contains 3 values. My range would then be (2,5)(4,5) if I'm correct.
  I'm just wondering how to specify this range using only integers instead of (E2:E4).
  Is it at all possible?</p>
  
  <p>I found this code to define a named range:</p>
  
  <pre><code>'Change the range of cells (A1:B15) to be the range of cells you want to define
      Set Rng1 = Sheets("Sheet1").Range("A1:B15") 
      ActiveWorkbook.Names.Add Name:="MyRange", RefersTo:=Rng1
  </code></pre>
  
  <p>Could anyone nudge me into the right direction to specify this range using integers only?</p>