title: Return Table Row number on Cell Change VBA
body: <p>Totally new to VBA. I am trying to identify the row in a table in which a cell change has occurred. If I change one of the cells in the last column of table, I want to pass the row along to a macro.</p>
  
  <p>I found the basis for the change code in another answer, and added my table range:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  If Intersect(Target, Range("Table4[Ready]")) Is Nothing Then Exit Sub
      Application.EnableEvents = False 'to prevent endless loop
  
      MsgBox Target.address
  
      Application.EnableEvents = True
  
  End Sub
  </code></pre>
  
  <p>How can I find that target.address is row 5 of table 4?</p>
  
  <p>Thanks</p>