I want to add a line to an overview list with the name of the suplier and his intern number (through input boxes) and at the same time create a new sheet in the same workbook for that supplier. All of this works but I also want to insert a hyperlink in the cell which contains the name of the new supplier (in the overview list) to the newly created sheet. I have written something like this but it doesn't work:
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= Sheet(Newnumber)!A10 with newnumber = the name of the newly created sheet.
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= Sheet(Newnumber)!A10 with newnumber = the name of the newly created sheet.