title: Excel 2007 VBA Get the row number of an active cell relative to its position in a range
body: <p>I have been beating myself to death trying to figure this out, my google search page is filled with visited links as I try wording my searches in a hundred different ways with no success!</p>
  
  <p>I have a range, say <code>A8:A17</code>, and the active cell is <code>A10</code>.  How do I get the row number of <code>A10</code> relative to the first cell in the range, <code>A8</code> (I would expect the result to be <code>3</code>)?  I want to use this value to reference another cell using <code>Range(exRange).Cells(exRow, 1)</code>.  The only way I can think of doing it is to loop through the range until the loop number is equal to the row of the active cell but there must be a cleaner way of doing it!</p>