I'm not sure what happened over there when you tried it out ..
(I don't know whether GS will come back here)
Here's my offer to you:
Download this sample file
It has GS' sub implemented & a set-up with dummy data
Try it out in Sheet2 (easy steps given):
http://www.freefilehosting.net/download/3f41e
Sub to Find n Replace.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---