I have spent the better half of today searching your forum for a solution to this but end up with finding code that creates hyperlinks by the column or row.
I Have a spreadsheet with some code which archives data into a summary sheet and creates a backup sheet of the detail. This all works really well.
In the summary sheet, I have a column that is named with the name of the new worksheet.
What I want to do is to be able to create a hyperlink from this name in the column to the new, backed up worksheet.
I do not want to create a list of hyper links, I only want to create on link at a time, each time I run the code.
Thanks in advance