Macro to replace word in formula

[mattress58]

I need to replace part of a formula. I need to delete the workbook reference: "[Combined Flow2.xlsm]". I need to do this for range A1:Z100 and this is what I recored when deleting them one at a time:

Please Login or Register  to view this content.

How can I do this to delete it from all worksheets for the range A1:Z100 besides one at a time. Thanks

[oeldere]

Untested, but you could give it a try.

Please Login or Register  to view this content.

[mattress58]

The

Please Login or Register  to view this content.

shows up in red when I paste it

[mattress58]

Ok, I took out the secound " and it works. The problem is that when it replaces on the box pops up to update values: sheet1 and I have to click cancel, or exit out of it, or hit esc to go to the next one

[oeldere]

Try this one instead.

Please Login or Register  to view this content.