update /delete external refs

[Paul]

I have written a macro and want to se it on older
workbooks.This requires that a new page replaces an
existing page.However all the references come over with
the new page.I want to use edit/find replace all to replace
[JUL02]Frame!C$6 with Frame!C$6 ie delete all references
to original worksheet.(or some other way!)

 

[Paul]

I have figured it out!.I copy the new page over to the old
worksheet and then change source of links back to itself!