Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
size of module
I am completing my project and have many small modules due
to keeping things separate. I would now like to combine many of the modules into one. But I recall seeing someplace the size of a module can not exceed 64k. Is that true? Beyond that, does a module have any size limit to it? Thanks for any advise. *** John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
size of module
Thanks Paul. I just read the string and it answered my
questions. Bottom line is, size does matter. *** John -----Original Message----- This is a fairly decent discussion on the issue of module size. http://www.google.com/groups?hl=en&lr=lang_en&ie=UTF- 8&oe=UTF-8&safe=off&th=9f72478edb61d7bf&rnum=7 HTH Paul ---------------------------------------------------------- ---------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. ---------------------------------------------------------- ---------------------------------------------------- I am completing my project and have many small modules due to keeping things separate. I would now like to combine many of the modules into one. But I recall seeing someplace the size of a module can not exceed 64k. Is that true? Beyond that, does a module have any size limit to it? Thanks for any advise. *** John . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
size of module
This is a fairly decent discussion on the issue of module size.
http://www.google.com/groups?hl=en&l...b61d7bf&rnum=7 HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- I am completing my project and have many small modules due to keeping things separate. I would now like to combine many of the modules into one. But I recall seeing someplace the size of a module can not exceed 64k. Is that true? Beyond that, does a module have any size limit to it? Thanks for any advise. *** John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CLASS MODULE & SIMPLE 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 | |||
Can we write VBA code to set all column/row's size back to default size? | Excel Programming | |||
Can we write VBA code to set all column/row's size back to default size? | Excel Programming |