Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Oops. I meant Module!
Sorry about the error and thanks for the correction. Harlan Grove wrote: "Dave Peterson" wrote... the rule of thumb around here is that procedures shouldn't be bigger than 64k when you export it to a text file. But that's just a rule of thumb. I don't think the actual limit is documented anywhere. .. 64KB in one module I can understand, but 64KB in one *procedure*? Even if lines of code averaged 64 characters (including the ending newline sequence), that'd be a 1024 line procedure, so spanning just a bit more than 17 60-line pages in printout. A single prodedure of that size is a REALLY BAD IDEA! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW TO CARRY A VAIABLE RESULTS FROM EXCEL SHEET PROCEDURE TO A MODULE | Excel Discussion (Misc queries) | |||
to call procedure in a worksheet in a module | Excel Discussion (Misc queries) | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |