spaces

[N1234]

Hello again!

I'm currently trying to hyperlink to specific excel worksheet names that have spaces in them. I can get it the hyperlink working without the spaces i.e:
C:\Users\Desktop\Excel.xlsx#Sheet1!A1. But if there's a space between Sheet and 1, i.e: Sheet 1, I can not longer get the hyperlink to work.

I've tried C:\Users\Desktop\Excel.xlsx![Sheet1]!A1 and C:\Users\Desktop\Excel.xlsx#'Sheet 1'!A1 but they both produce errors.

Thanks again for your help!

 

[Isaac]

Skip the hyperlink and just write code to open the path when they click somewhere/thing

 

[bastanu]

Have you tried C:\Users\Desktop\Excel.xlsx#'" & "Sheet 1" & "'!A1?

Cheers,

 

[Pat Hartman]

Whenever a variable contains spaces or non-standard characters, you should enclose the string in double quotes.

FollowHyperlink  & """" & Me.txtLink & """"

 

[CJ_London]

so far as I am aware, excel does not allow spaces in range names

 

[Gasman]

so far as I am aware, excel does not allow spaces in range names

Sheet names are fine though?

 

[CJ_London]

good point