Creating hyperlink based on passed range

[Dr. Demento]

I'm trying to create a hyperlink based on a passed range. The link location I can manage, but the destination sheet/range is giving me fits.

I can assign the destination sheet using the .Parent function, but I can't pair the sheet and range for anything! The function quits at setting the Range. I assume the final range needs to be Sheets(gnr.parent).Range(gnr) but that doesn't work.

What am I doing wrong??

Set shtLinkDest = gnr.Parent
  With shtLinkDest
    Set rngLinkDest = .Range(gnr)
  End With

I'm using Tim William's code below to create the hyperlink (excel - Create Hyperlink to sheet in cell VBA - Stack Overflow) but it never progresses that far.

cellHyperlink rngLinkLoc, _
              rngLinkDest, _
              CStr(rtsdata)

Thanks y'all!

 

[Dr. Demento]

Turns out that using gnr without specifying the sheet for the cellHyperlink function works just fine. However, I don't really understand why. I thought that without a sheet reference, the range could point to any sheet (usually the activesheet??) but the passed range implicitly knows which sheet it directs to. What am I misunderstanding?