Changing formulae links

[nirajrana]

I am copying formulae from an old version of a template, into a newer
one, using a macro. Unfortunately, when the macro copies over the
formulae, it references them to cells in the old worksheet, not the new
one. I know I could use :

ActiveCell.ChangeLink Name:= _
"old template", NewName:= _
"current/new template", Type:=xlExcelLinks

But the problem with this is that it changes links for the whole
workbook. While I do want to change the links in some cells, I also
want to keep them for others. Is there any VBA code to change links
individually for cells?

 

[Guest]

select the cells, then do Edit=>Replace

old link string

new link string