merge VBA Modules

[jallum]

Hi there. I'm in the process of re-organizing a maco-enabled worksheet that was passed over to me.
There are over 100 separate modules under vba, some of which contain multiple functions and subroutines, and some that are totally empty.
Is there a way to merge all of the modules into a single module that would contain all of the VBA code, or am I stuck slogging through all of them?

 

[Joe4]

If there are a number of them, I would NOT put them all in one module. That would make it very hard to locate anything and hard to work with.
And there is a size limit on modules (Box).

I would recommend first deleting all the blank ones.
Then group the ones that make sense in a handful of modules (group them, according to task, function, or whatever makes sense).

It will take a little while to clean-up, but it will make it much easier to maintain and reference going forward.

 

[jallum]

I did not realize that there was a size limit on the modules. Good to know, and a-slogging I shall go...

 

[Joe4]

I did not realize that there was a size limit on the modules. Good to know, and a-slogging I shall go...

Yeah, cleaning up other's messes is always fun!
Good luck!

 

[tonyyy]

Jon Peltier of Peltier Technical Services has a utility that will list all the vba procedures by module, appropriately called List VBA Procedures by VBA Module... It might prove useful in organizing your 100+ modules.

Cheers,

Tony