vba jump to row

[meytithveasna]

Hi Group. Is it possible to link to a specific row in another sheet? I have a sheet that tells me the row number in another sheet (same workbook)
where additional info is located.
I'm hoping to create a link that will take me to that specific row in the other sheet.
Can that be done?

 

[Caleeco]

Hello,

Without knowing much about your sheet setup, you can have a go modifying the code below (see comments)

Sub JumpRow()
Dim ws1 As Worksheet
Dim ws2 As Worksheet
Dim RowNum As Long


Set ws1 = Sheets("Sheet1") 'Change this to the sheet name containing your row number
Set ws2 = Sheets("Sheet2") 'Change this to the sheet name you wish to jump to


RowNum = ws1.Range("A1").Value 'Change this cell to where the row number is located
ws2.Activate
ws2.Range("A" & RowNum).Select


End Sub

Hopefully that does what you require
Caleeco