Modules - Save each code in seperate module? or group like code in

  • Thread starter Thread starter BEEJAY
  • Start date Start date
B

BEEJAY

Have approx. 75 modules in my Personal.xls file.
I have tried both ways - Combine like code into one module
and (currently) seperate module for each code.

1. What are pros and cons of each?
If I group my codes, I can get down to about 12 modules.
2. Will the auto saving of the Personal.xls be much faster that way?

However, If grouped, I find it a pain to have to scroll up and down so much,
while trying to find code that I want to use in another code set.

3. Is there a way to open TWO sheets of the same module?

Thanks for any input.
 
Packaging your subs and functions into modules can be helpful if you need to
export the subs in groups.
 
Back
Top