Find/replace in headers and footers

[pete1001]

I have a many-worksheet workbook and need to find/replace in the header and footers. Each header and footer is slightly different so usual multiple selection of sheets and editing won't work.

Any ideas?

 

[Edrondol]

This worked for me when I tried it. If it works for you it'll be the easiest fix ever. Have you tried doing a find/replace without the header/footer open? In my version of Word (97) it goes through the document, then starts to search the header/footer. I did this on several different documents and it worked every time. Let me know if this doesn't work & I'll try something else.



-Dave

 

[Edrondol]

Well, reading was never my strong suit. It doesn't work in Excel. Let me look at it some more and I'll try to make up for my earlier brain-freeze.


-Dave