Macro to replace multiline VB code across mutiple worksheets

[srvcjlo]

I'm trying to write a subroutine function that can replace the same piece of multi-line VB code in multiple worksheets. And the following is the problem i encounter:

1. the replace option in the VB editor cannot replace multiline codes
2. there were alpha versoin plugins available but it doesn't have "replace all" option so i have to click a hundred times (i have over a hundred worksheet)

so basically i will need to write a vb function to change the content of other functions. can anyone tell me if such code can be written.

 

[acw]

Hi

Have a look at

http://www.cpearson.com/excel/vbe.htm

Has some details on how to modify VBA code, using code.


Tony