|II'm quite new on here, actually completely fresh so please excuse me if this has been covered already.|
I'm trying to get 58 tabs, all of which contain the same report, linked to a list on a contents sheet at the front.
There has already been a posting before but i cant reply to it as its too old.
I followed these instrustions:
For Each cName In Sheets(1).Range("A1:A4")
ActiveSheet.Hyperlinks.Add Anchor:=cName, Address:="", SubAddress:= _
cName & "!A1", TextToDisplay:=cName.Value
But what i've found is that it doesn't hyperlink to the sheet because it is shown as 'The Sheet' instead of The Sheet.
I'm hoping someone can help because ive gone through the 58 sheets twice now, once to link the sheet to the title and another to get the same name on the tab.
Its too fustrating!