VBA Code to create hyperlink using cell content

Question

I have an excel workbook in which the first sheet contains names of the other worksheets in the same workbook. e.g. Cell A2 has a value "Names" -- Names is the name of the worksheet

I need to convert the content of A2 cell to a hyperlink which takes me to the "Names" worksheet.

Answer 1

Why not use the hyperlink function in column B:

=HYPERLINK("#'"&A1&"'!A1",A1)