Martijn

Unregistered less info
21 reputation
112
bio website
location
age
visits member for 4 years, 1 month
seen Jul 16 '10 at 9:44

Oct
29
awarded  Famous Question
May
17
awarded  Notable Question
Mar
24
awarded  Student
Nov
16
awarded  Popular Question
Jul
16
comment Hyperlink to other worksheet using hyperlink function in excel
@DMA57361 Thanks for your help.. the brainstorming did it for me....;)
Jul
15
comment Hyperlink to other worksheet using hyperlink function in excel
Got it...! Here's the solution: =HYPERLINK("[Verlofkaarten.xlsm]" & A2 & "!A1";"Name")
Jul
15
comment Hyperlink to other worksheet using hyperlink function in excel
Ok, got the simple one to work.. Now trying to create the string as shown beneath.. any idea why this doesn't work..? The name of the tab is in A2. =HYPERLINK("[Verlofkaarten.xlsm]'&A2'!A1";A2)
Jul
15
comment Hyperlink to other worksheet using hyperlink function in excel
Still can't get even the simple function to work.. Still gives a path error. Tried using "Cell" then copy pasted the value in [File].. path error. Tried writing down the UNC path, still an error.. can't understand what I'm doing wrong here..
Jul
15
comment Hyperlink to other worksheet using hyperlink function in excel
Thanks for your answer. I first tried your first option to test if the basics work, but excel gives me the error that the file can't be opened. Doesn't the first option have to be combined with a full path name? I tried this before also using the "cell" function but couldn't get it to work, maybe you can help me out...
Jul
15
asked Hyperlink to other worksheet using hyperlink function in excel