I have a "Search Replace Code" example on my website.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"R.VENKATARAMAN" &&& wrote in message
...
sorry for this strange question. Is it possible to write a vba procedure
to
change another sub. for e.g. in a sub I want to replace certain text or
number by another text or number particularly when this particular text or
number occurs a number of times.