Hi <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>
<o></o>
I am busy bodily creating loads and loads of reports statistics on multiple worksheet. At one time I am even going through a large loop creating 30-40 worksheets i.e. for all business unit.<o></o>
<o></o>
I have approx 25 modules (for ease of coding I have just named the module sensibly). I.e.<o></o>
<o></o>
Lib00_Create_Worksheet<o></o>
Lib01_Process_All_Data_Rows<o></o>
Lib02_Create_Charts_A<o></o>
Lib03_Create_Charts_B<o></o>
Lib04_Create_Chart_C<o></o>
Lib05_Create_Charts_D<o></o>
Etc…<o></o>
Etc…<o></o>
Lib25_Create_Summary.<o></o>
<o></o>
I have got quite a lot of code in the entire excel file with almost 5 user forms they can fill in. <o></o>
<o></o>
When trying to add more code modules, I get the message “Out of Memory”. <o></o>
<o></o>
Can anyone help ?<o></o>
<o></o>
Thanks in Advance. Kuldip
fficeffice" /><o></o><o
></o>I am busy bodily creating loads and loads of reports statistics on multiple worksheet. At one time I am even going through a large loop creating 30-40 worksheets i.e. for all business unit.<o
></o><o
></o>I have approx 25 modules (for ease of coding I have just named the module sensibly). I.e.<o
></o><o
></o>Lib00_Create_Worksheet<o
></o>Lib01_Process_All_Data_Rows<o
></o>Lib02_Create_Charts_A<o
></o>Lib03_Create_Charts_B<o
></o>Lib04_Create_Chart_C<o
></o>Lib05_Create_Charts_D<o
></o>Etc…<o
></o>Etc…<o
></o>Lib25_Create_Summary.<o
></o><o
></o>I have got quite a lot of code in the entire excel file with almost 5 user forms they can fill in. <o
></o><o
></o>When trying to add more code modules, I get the message “Out of Memory”. <o
></o><o
></o>Can anyone help ?<o
></o><o
></o>Thanks in Advance. Kuldip
