Hello, I would like to hyperlink to another sheet using the indirect Reference.
I have this so far but when clicked it says cannot open the file specified.
Does anyone know whal else I need to put in to link this cell to another sheet in the same workbook?
Please Login or Register to view this content.
Regards,
Tom
You need to use # to indicate it's a relative bookmark and then along the lines of:
=HYPERLINK("#'"&B6&"'!A1",1)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks