Hello cuyuni,
Here is the code for a UDF (User Defined Function) that will automatically update the link when the Worksheet name is changed. Paste this code into a VBA module in Workbook1. If you need help with installing a Module in the Workbook, let me know in your next post.
For example let's say A1 on Worksheet1 is to be linked to D1 on Worksheet2...
A1 would intially contain =LinkCells(Sheet2!D1)
Now, let's change Worksheet2's name to "clac's"...
A1 will now update and contain =LinkCells('calc"s'!D1)
Sincerely,
Leith Ross
Bookmarks