Opinion on Size/Length of Macro/Function/Sub
As a novice programmer, I second Jim's advice. If you can modularize your
code it makes it a lot easier to manage, especially if you have a routine
with a lengthy algorithm that you need to run more than once. I cut one of
my first programs in half after I learned how to call the sub routines from a
master sub. Even if it is a file save exercise you can use a one line call
as opposed to three lines or more each time.
"Rob" wrote:
Should I have 13 seperate Macros or one long Sub/Macro??
I was wondering if I can get some opinions on this subject. The reason is
because I have a Workbook that has a Macro/Sub that has 600 lines of code in
it. But here's the thing... The code I have performs like 13 different
routines that could be broken out seperately.
Your opinions are most certainly valuable to me so please enlighten me.
Thanks Tons.
Rob
|