Change code with code?
 

Hi All..........

I would like to have a macro that would go into all the code in all modules
of my file and do a "Find and Replace"...............recording, just don't
get it.
For example, I would like to replace all instances of _GB with
_CR......whether it be in remmed out comments or active code.

TIA
Vaya con Dios,
Chuck, CABGx3

Change code with code?
 

Give Chip's site a look if you have not already...

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

Jim Thomlinson


"CLR" wrote:

Hi All..........

I would like to have a macro that would go into all the code in all modules
of my file and do a "Find and Replace"...............recording, just don't
get it.
For example, I would like to replace all instances of _GB with
_CR......whether it be in remmed out comments or active code.

TIA
Vaya con Dios,
Chuck, CABGx3

Change code with code?
 

Thanks Jim.......
I'll give it a shot.

Vaya con Dios,
Chuck, CABGx3



"Jim Thomlinson" wrote:

Give Chip's site a look if you have not already...

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

Jim Thomlinson


"CLR" wrote:

Hi All..........

I would like to have a macro that would go into all the code in all modules
of my file and do a "Find and Replace"...............recording, just don't
get it.
For example, I would like to replace all instances of _GB with
_CR......whether it be in remmed out comments or active code.

TIA
Vaya con Dios,
Chuck, CABGx3