title: Set range from used range offset
body: <p>I would like to build a range to do work on.  I am able to return the row and column indices of last used cell but how do I include this in a named range?</p>
  
  <pre><code>numRows = sht.Cells(Rows.Count, 2).End(xlUp).Row
  numColumns = sht.Cells(1, Columns.Count).End(xlToLeft).Column
  
  Set endRange = sht.Cells(numRows, numColumns)
  
  Set workRange = sht.Range("B1", Cells(numRows, numColumns)?
  </code></pre>