replace macro?

[andrewm]

Hi,

I would like to replace a name eg. "andrew" with "trudy" in all of the worksheets at once.

how can I do it?

andrewm

[Bob Phillips]

Have you tried Find & Replace (Ctrl-H)?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"andrewm" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> I would like to replace a name eg. "andrew" with "trudy" in all of the
> worksheets at once.
>
> how can I do it?
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=477464
>