Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Out of Memory" error in editor
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? -- Trefor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Out of Memory" error in editor
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" 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? -- Trefor |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Out of Memory" error in editor
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. -- Trefor "Jim Cone" wrote: 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" 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? -- Trefor |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Out of Memory" error in editor
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" 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. -- Trefor "Jim Cone" wrote: 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" 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? -- Trefor |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Out of Memory" error in editor
Jim,
Many thanks for your reply. As mysteriously as this error came, its gone. I am not sure whats going, but I will be sure to try this if it comes back. Many thanks. -- Trefor "Jim Cone" wrote: 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" 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. -- Trefor "Jim Cone" wrote: 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" 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? -- Trefor |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Out of Memory" error in editor
Jim,
Many thanks for the reply. As mysteriously as this error came, its gone. I am not sure whats going, but I will be sure to try this if it comes back. Many thanks. -- Trefor "Jim Cone" wrote: 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" 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. -- Trefor "Jim Cone" wrote: 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" 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? -- Trefor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The Instruction at "0x749860a0" referenced memory at "0x00000000" | Excel Discussion (Misc queries) | |||
Runtime Error "7": Out of Memory | Excel Programming | |||
Excel:Runtime Error 7 "Not enough Memory" with CreateObject (SAP.B | Excel Programming | |||
too many external links give "Not Enough Memory" error | Excel Programming | |||
The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc | Excel Programming |