Module Usage

[helpexcel]

Hi - I have a general questions about whether it's best to put all your code into 1 macro, or create separate modules for each procedure and then call them? thanks!

 

[Joe4]

Note that you can have multiple procedures/functions within the same module (you do not need a separate module for each procedure).

A lot of it is personal preference. I tend to not like to overwhelm my procedures and make them too big, so I like to break them up into logical chunks. It can make debugging them a little easier too.
Another reason for doing this is you can make your procedures reusable, especially if you make them generic and feed in parameters. So you can improve efficiency that way.

 

[Fluff]

As Joe said it's personal preference.
I tend to prefer all code in one procedure, with the exception of a few functions

 

[helpexcel]

Thanks for the feedback!

 

[Fluff]

You're welcome

 

[mikerickson]

One of the tenants of Structured Programming is that each routine should do one thing.
So, large routines should be avoided and replaced with routines that call many different small routines when needed.

(Now I need to go see if I implied that Structured Programming is a landlord. )