Global Replace

[HankH]

Hello Group. Can someone help me? Is there a way to do a
global replace in which every instance of a certain string
through a workbook (I'm talking all worksheets, and in
particular the headers and titles of various charts
therein) can be Replaced with different a different piece
of text?

A ton of thanks. Hank Harris


Hank Harris
Coordinator of Assessment
Santa Monica-Malibu Unified School District
Santa Monica, California 90404 USA
(e-mail address removed)

 

[Dave Peterson]

This was added in xl2002. And I don't think it'll search|Replace in headers,
charts, and so forth.

 

[Dave Peterson]

You could try Jan Karel Pieterse's FlexFind:
http://www.bmsltd.ie/MVP/

It'll get the headers.
And it'll find in textboxes (placed on the worksheet and placed on a chart).
It gets comments.

But I inserted a hyperlink and it didn't get that in the address (not the text
to show).

(Maybe next version, Jan Karel????)