I need to run a macro on change of values in a range having forumlas in
various cells. The below logic doesn't work unless the cursor is in the given
rangevalue

If Not Intersect(Target, Range("rangevalue")) Is Nothing Then
MsgBox "Cell has changed"
End If

Since my cells are having formulas, they change automatically with change in
other ref. cells.