I currently have the below macro set up so that i enter a cell in V2 and click a button and it jumps to that cell. How do I modify it so that it activates whenever cell V2 changes, rather than having to click the button?
Private Sub JumpTo_Click()
Dim C, R As Range, Cell As Range
Set R = Range("C1:C4000")
C = ""
For Each Cell In R
If Cell.Value = ActiveSheet.Range("V2") Then
C = Cell.Address
End If
Next
If C = "" Then
MsgBox "NOT FOUND " & ActiveSheet.Name
Exit Sub
Else
Range(C).Offset(0, 0).Select
End If
End Sub
Bookmarks