R
Ross Bennett
Why are new macros created on additional modules ?
Is there a reason why all macros can't be on the same module ?
Is there a reason why all macros can't be on the same module ?
C
Chip Pearson
Ross,
The Macro Recorder tends to put recorded code in new modules.
You can have as many macros in a single module as you please, up
to a total number of lines of about 5000.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
The Macro Recorder tends to put recorded code in new modules.
You can have as many macros in a single module as you please, up
to a total number of lines of about 5000.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
P
Peo Sjoblom
That happens if you record a macro, you can put multiple macros in the same
module,
copy them from the other modules and past below each other and excel will
insert a divider.
Then right click the empty modules and select remove and when prompted say
no
when you get asked about exporting
module,
copy them from the other modules and past below each other and excel will
insert a divider.
Then right click the empty modules and select remove and when prompted say
no
when you get asked about exporting
H
Harald Staff
Hi Ross
To the "why" question:
I don't know
But my impression is that if you record and then record and then record then they pile up
below eachother in Module1. But if you open Module1, copy, edit or maybe not even that
much, then the module is flagged as "in use" and the next recording creates a new one.
Just an impression.
To the "why" question:
I don't know
But my impression is that if you record and then record and then record then they pile up
below eachother in Module1. But if you open Module1, copy, edit or maybe not even that
much, then the module is flagged as "in use" and the next recording creates a new one.
Just an impression.