Hyperlink - Reference is Invalid

[stuartgb100]

Hi,

I've a list of hyperlinks in sheet "#Artists-Index" (in the code this is TargetSht).
The links are generated from sheet "#Artists' Name & Album Titles" (in the code this is SourceSht).
All the links return the same error.

In the code I have:

Set SourceSht = Sheets("#Artists' Name & Album Titles")   '2
'Set SourceSht = Sheets("#Master-Artists,Albums,Tracks")   '1
Set TargetSht = Sheets("#Artists-Index")

If I run the code using 1, it works.
If 2, it does not.

What I have found is this:
If I right click a working link and choose Edit Hyperlink, then I can see the correct cell reference.
However, all the 'not working' links show "A1".

Any ideas please ?
Thanks.

 

[Kerryx]

Issues with space characters in hyperlink destination sheet names

 

[stuartgb100]

Thanks.

If I understood you correctly,
I changed the SourceSht name and then changed the Set line to:

Set SourceSht = Sheets("#Artists'_Name_&_Album_Titles")

However, this gave the same error.

Cheers.

 

[stuartgb100]

Working now.

Tried several things and then found that the problem was the apostrophe.

Thanks again for your help.
Regards.