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

[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.

 

[Gary''s Student]

Packaging your subs and functions into modules can be helpful if you need to
export the subs in groups.