Using a macro to alter another macro

[paulsolar]

Hi All

I'm hoping this is possible, but doubt if it is.

I have a macro that works fine, it is for producing sales managers reports, the only problem is that if a sales manager leaves I have to alter the macro in several places which is a right pain for me.

The sales managers name us used as part of the sub title and in the body of the macro.

What I'd like to do ideally is have a separate worksheet, say called "change sales managers" and a user form where they enter the outgoing sales managers name and the name of the replacement sales manager. Then do a find and replace in the report generating macro. Currently I have to do this manually using find and replace. It doesn't take long but it always needs doing whist I'm away from the office.

Any ideas where to start would be appreciated and is it possible to change the name of a sub in another macro using a macro??

Many thanks in advance

Cheers

Paul

 

[davesexcel]

You can use the macro recorder for find and replace to get the code, then edit it to clean it up.

 

[paulsolar]

Never even considered this