title: Finding relative row and column number of a range OR Cell
body: <p>Is it possible to find the relative row and column number of a range or cell within a Range.</p>
  
  <p>Example:
  In the following Table (Table Name "Table2")
  <img src="https://i.stack.imgur.com/ysbEl.jpg" alt="Example Table Data"></p>
  
  <p>If I use the Find method and print the address like so:</p>
  
  <pre><code>Dim loHeaderRow As Range
  Set loHeaderRow = ThisWorkbook.Worksheets("Sheet3").ListObjects("Table2").HeaderRowRange
  Dim rFindResult As Range
  Set rFindResult = loHeaderRow.Find(What:="MajorVersion", LookIn:=xlValues, LookAt:=xlWhole, MatchCase:=False, SearchFormat:=False)
  
  MsgBox rFindResult.Address
  </code></pre>
  
  <p>will Print </p>
  
  <pre><code>$C$3
  </code></pre>
  
  <p>But the relative location of the range rFindResult with in the parent range loHeaderRow is:</p>
  
  <pre><code>Row number: 1
  Column Number: 2
  </code></pre>
  
  <p>Can this be achieved? Especially so by using standard object properties/methods without needing a long set of code?</p>