"Out of memory" message from VB script window

[jeeves]

I have VB script that is about 100K lines, and when i paste that into the VB window in Excel (I right clicked on the Workbook and Inserted a Module), I get an "Out of memory" error message.

If my script is about 65K lines, it works fine.
Apparently 100K is too big.
Does anyone know of a way I can increase some memory setting or some setting in Excel/VB such that it can take bigger VB scripts ?

thanks in advance.
sq

 

[davidhall80]

Whenever I get that message or the "procedure to big" message, I split my macro into 2 macros. The end of my first macro commands the start of my second macro. In this example, I put an "End Sub" after what is below and then I have my second macro titled "Hide". Just make sure you make sure it is pulling from the correct module.



Application.Run "PERSONAL.XLS!Hide"

 

[jeeves]

>"Whenever I get that message or the "procedure to big" message, I split my macro into 2 macros"

Actually that "trick" I am already using, ie, splitting the procedures and setting up the calls such that all code is executed.

However, I am not getting a "procedure too big" message, but am getting an "Out of memory" message, which I think means that the overall
VB script code in the Module window is more than it can handle/has memory for.