title: Declare a Range relative to the Active Cell with VBA
body: <p>I need to declare a range object relative to the Active Cell.  The problem is, the number of rows and columns I want to select is different each time the macro runs.</p>
  
  <p>For example, I have two variables: <code>numRows</code> and <code>numCols</code>.</p>
  
  <p>I want to select a range that has the ActiveCell in the upper-left corner hand has the cell with row ActiveCell.Row + NumRows and column ActiveCell.Column + NumCols in the bottom right (and then I intend to copy this data to an array to speed up my macro).</p>
  
  <p>Any suggestions on how to do this?</p>