Hi all,

I have a worksheet with many links. I want to copy this sheet and
create another sheet with the same links. The only difference is that
the links to the worksheet name must be changed, the workbook name and
ranges will stay the same.

I have tried to find/replace in the formula but it doesnt work.
How do i change the source (as it does when you open a workbook with
broken links)

Thanx in advance :)