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