I'm trying to get a code to work to put the link the another cell in a worksheet. I got a version of it working but it keeps erroring out when there is an Apostrophe in the name such as "Master's data"
This is how i wrote the code
"='" & Worksheets(i).Name & "'!" & Worksheets(i).Cells(3, 5).Address
I just want it to spit out this ='Master''s data'!D5
This is how i wrote the code
"='" & Worksheets(i).Name & "'!" & Worksheets(i).Cells(3, 5).Address
I just want it to spit out this ='Master''s data'!D5