new module for recording macros

[lezawang]

Hi
I inserted a module and wrote a macro there. Then went to excel and recorded a macro. I went back to VB editor and found that excel inserted a new module and put recorded macros in that module and my first module was not touch. Now when I record any macro, the new recorded macro will go to the second module which has the previous recorded macros. Is that how excel designed? Why not excel added the recorded macros in my first Module? Thank you very much.

 

[Artik]

Is that how excel designed?

Yes.

Why not excel added the recorded macros in my first Module?

After recording, you can transfer the recorded code (Ctrl+x and Ctrl+v) to your module, and delete the empty module.

Artik