title: VBA check changes in a particular cell range
body: <p>I need a function that checks if a particular range of cells in vba was changed:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
     If Not Intersect(Target, Range("A9:J100")) Is Nothing Then
        MsgBox Target.Address
     End If
  End Sub
  </code></pre>
  
  <p>This code works, the problem is: they changed to the same values (throw an internet update). How to check if the updated cell values really changed to new ones? (without checking one by one ofc)</p>
  
  <p>Thanks in advance</p>