ou81aswell
Board Regular
- Joined
- Oct 6, 2009
- Messages
- 50
How do I specify the worksheet name to the HYPERLINK() function when the worksheet name contains a double-quote? Is there a way to "escape" the double-quote somehow?
The sheet I'm having trouble with is called 4" Nails. What changes would I have to make to the following hyperlink function in order for it to work?
=HYPERLINK("[MyWorkbook.xlsx]'4" Nails'!A1","4" Nails")
Thanks.
The sheet I'm having trouble with is called 4" Nails. What changes would I have to make to the following hyperlink function in order for it to work?
=HYPERLINK("[MyWorkbook.xlsx]'4" Nails'!A1","4" Nails")
Thanks.