View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MarkN MarkN is offline
external usenet poster
 
Posts: 104
Default Find and Replace

Hello,

I have a load of workbooks in different locations where the location of one
of the links has changed. I'm not sure how to go about this but what I want
to be able to do is
-select a workbook but not be prompted to update links
-find any formulas with links including "Z:\" and replace with "F:\"
anywhere in the workbook.
--
Any help appreciated,
MarkN