Should work.

But why not just do it manually in the VBE under Edit=Replace

--
Regards,
Tom Ogilvy

"Matthew McManus " wrote in
message ...
On the same idea, I want to find and replace a text string "zzz" with
"yyy" in macro1. Can I write another macro to do this?

Thanks
Matthew


---
Message posted from http://www.ExcelForum.com/