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