Once a user has selected an item from the drop down in Cell A1 on the active sheet ("Adjustments
using Data Validation , the user double clicks on A2 , which has a hyperlink formula, and it will then go to the appropriate cell
I tried to write code to do this, but it only goes to A2 and does not go to the appropriate cell for Eg A55
Kindly amend my code

I tried to write code to do this, but it only goes to A2 and does not go to the appropriate cell for Eg A55
Kindly amend my code
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then 'Change "$A$1" to the cell address of your drop down list
On Error Resume Next
Dim hyperlink As hyperlink
Set hyperlink = Range("A2").Hyperlinks(1)
On Error GoTo 0
If Not hyperlink Is Nothing Then
hyperlink.Follow
End If
End If
End Sub