We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next Application.EnableEvents = False Application.ScreenUpdating = False If Target.Address = Range("A3").Address Then Application.GoTo Worksheets(Range("AC2").Value).Range("A3") End If Application.EnableEvents = True Application.ScreenUpdating = True End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|How to resolve run time error "1004" name more than 31 charaters long||12||48|
|Why would a IF THEN result jump up to a prior line in the VBA code||12||50|
|Modify to work without control shift enter||9||35|
|Color a cell based on a date in Excel||8||23|