Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Use good programming practives. Usually around 200 - 250 line of code per
module is the limit. Better than the 500 punch cards I had to use in college. Consider how you are going to tet the code in making the decision to have one or multiple modules. You didn't say if you where building a subroutine or a function, but it is always good to create sub-functions where possible. "Dave Birley" wrote: I said I was OLD, couldn't remember the word "module" to save my life. Not ignorance, just a little "Halfzheimer's" <g). Non "Process" est, sed "Module". Mea culpa <g! -- Dave Temping with Staffmark in Rock Hill, SC "Dave Birley" wrote: I'm building a Macro that is growing "like Topsy". At the moment it is 145 lines long, and will increase by about 50% from there when done. Because I'm an old (really OLD<g) VFP programmer, my thinking and development pattern is shaped by that experience. So, is it considered bad form to have a macro get large? I recall that in C++ the recommendation was to try to hold a process to one screenful where possible, and then build a "parent" process that called the segments in sequence. However my macro consists of a series of nested For Loops that goes five or six levels deep. Just wondering -- and trying to learn <g! -- Dave Temping with Staffmark in Rock Hill, SC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
limit on size of macro for excell97 | Excel Discussion (Misc queries) | |||
Array size limit | Excel Programming | |||
Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) | |||
Size Limit for ADO query? | Excel Programming | |||
Macro Size Limit / open macros with macros? | Excel Programming |