Excel Hyperlink to Sheet

[SIG357]

Im trying to set a hyperlink in VBA to a seperate sheet in the same workbook.&nbsp;&nbsp;I know this can be done strictly in Excel, by right clicking, choosing hyperlink, etc. etc., but I can't figure a way to do it in code.&nbsp;&nbsp;I can't really use a macro, because the name of the sheet is going to be dependent upon the text in the cell that is hyperlinked.&nbsp;&nbsp;Any help would be greatly appreciated.&nbsp;&nbsp;Thanks.<br><br>Joe

 

[Ruairi]

Have you tried recording a macro to see what the code will look like, then rewriting it to suit your needs. This is usually a very easy way to learn how to do things in excel vba.

 

[SIG357]

Haven't tried it yet, but thanks for the tip
Joe