title: Get row number on Cell Change in VBA
body: <p>I know how to check to see if a column has changed, like so</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      If Not Intersect(Target, Range("H5")) Is Nothing Then 
          'Pop up a message saying H5 has changed
      End If
  End Sub
  </code></pre>
  
  <p>If I want to change another column on the same row, I can do this</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      If Not Intersect(Target, Range("H5")) Is Nothing Then 
          Range("A5").Value = "Look at me!"
      End If
  End Sub
  </code></pre>
  
  <p>Now what if I want to achieve the above, but for all columns in the range of row1 to the end of the table? Something like this (note, I know this wouldn't work)</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      If Not Intersect(Target, Range("H1:H")) Is Nothing Then 
          Range("A" &amp; Target.row).Value = "Look at me!"
      End If
  End Sub
  </code></pre>