Hi

See Chip's page
http://www.cpearson.com/excel/vbe.htm
on this.

HTH. Best wishes Harald

"R.VENKATARAMAN" &&& skrev i melding
...
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.