Hyperlinks issue
 

Hi Folks,

I have an issue with hyperlinks. I have 2 links that go from one tab
to another tab on in the same file. The code I am using is the
following:

'Create hyperlink to the Cap by tab
Range("B" & loutput2currentRow - 2).Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection,
Address:="", _
SubAddress:="'Cap by Site'!D" & loutputcurrentRow

'Create hyperlink to the Site Info tab
Sheets("Temp Output").Select
Range("D" & loutputcurrentRow).Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection,
Address:="", _
SubAddress:="'Site Info'!A" & loutput2currentRow -
cReportLength

These links used to both work at some point but have made additional
changes to the code, and now for some reason the second one creates a
link with the following characteristics and it no longer works. It
has the characteristics of 'Place in this document', and in the 'type
the cell reference' it contains A1 every time the code is executed
(which is not the correct value based on the content of the variables
of loutput2currentRow and cReportLength).

The first one hyperlink created that still works has the
characteristics of 'External File or Web Page' , 'Current Folder' and
address of: #'Cap by Site'!D2

I think I am overlooking something simple. Can anyone see it? Or if
they have a recommendation to try something else? I have tried a
number of things, all of which don't work.

Thanks & regards,
Enzo