"Out of Memory" error in editor

  • Thread starter Thread starter Trefor
  • Start date Start date
T

Trefor

I have some very large macro's/VBA 40K+ lines of code. It has been working
fine and still runs ok, but if there is an error and it drops into the editor
and I try and copy/paste a line of code I get "Out of Memory". If I type the
line in from scratch it works fine. I rebooted the PC in case there was
something weird happening, but it did not make any difference. I have finally
reached the limits of Excel?? Any suggestions?
 
Patient: "It hurts when I do this."
Doctor: "Don't do that."

Prescription: VBE (toolbar) | Insert | Module
(use as often as needed)
--
Jim Cone
Portland, Oregon USA



"Trefor" <[email protected]>
wrote in message
I have some very large macro's/VBA 40K+ lines of code. It has been working
fine and still runs ok, but if there is an error and it drops into the editor
and I try and copy/paste a line of code I get "Out of Memory". If I type the
line in from scratch it works fine. I rebooted the PC in case there was
something weird happening, but it did not make any difference. I have finally
reached the limits of Excel?? Any suggestions?
 
Jim,

Thanks, but the code is not all in one module. I have it accross 30 modules
and forms. This particular module only has 700 lines of code in it.
 
For the problem module try...
copying the code and pasting it into Notepad.
delete the problem module.
insert a new module.
copy the Notepad code and paste it into the new module.
--
Jim Cone
Portland, Oregon USA




"Trefor" <[email protected]>
wrote in message
Jim,
Thanks, but the code is not all in one module. I have it accross 30 modules
and forms. This particular module only has 700 lines of code in it.
 
Jim,

Many thanks for your reply.

As mysteriously as this error came, it’s gone. I am not sure what’s going,
but I will be sure to try this if it comes back. Many thanks.
 
Jim,

Many thanks for the reply.

As mysteriously as this error came, it’s gone. I am not sure what’s going,
but I will be sure to try this if it comes back. Many thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Out of Memory" error 4
"Out of memory" error message 1
Error 400 in VB editor 3
clearing memory using VBA 1
out of memory error 3
Can't access memory stick 6
Runtime Error '7': Out of Memory 3
Out of Memory 1

Back
Top