update /delete external refs

  • Thread starter Thread starter Paul
  • Start date Start date
P

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!)
 
I have figured it out!.I copy the new page over to the old
worksheet and then change source of links back to itself!
 
Back
Top