Hi,
I am trying to use vba to insert a hyperlink function in a cell, but I get a compile error message. It just says, "Compile error: Syntax error"
The line of code that is giving me the problem is:
If I change the hyperlink function to another formula like a vlookup, it works fine.Range("C2").FormulaR1C1 = "=HYPERLINK("#"&"'"&RC[-1]&"'!A1","Go to Sheet")"
How can I make the hyperlink function work?
Thanks,
Carlos
Bookmarks