This is the code that I have generated.
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
So I can create a link to a page if I know the name. What I have done is created a process that creates a new page from this specified codes i.e 1C 2C or 3C or whatever. But how I edit the line so that it will automatically take the code and link to the sheet without me having to specify the name in the coding?
Does this make sense