dynamic hyperlink....... in a loop

[dkaltsas]

HELP! I am trying to make the sheet name dynamic in the code below... Can someone help? I tried Worksheets.cells(1,1) in place of 'Sheet1'.... but it won't take it... What am I doing wrong?

Thanks,

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"'Sheet1'!A1", TextToDisplay:=acctnumber

 

[Oaktree]

Try:

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
 "'" & y & "'!" & Cells(1, 1).Address, TextToDisplay:="acctnumber"