Hi.
Some time ago I was developing a worksheet with a large amount of code in it, and I got some kind of 'out of memory' error.
I seem to remember it turned out that the error was because I had too much vba code in a single worksheet.
I think I overcame the problem by moving routines out of the sheet and into a module.
I'm probably going to be approaching this limit again with something I'm wroking on now (although I haven't had any errors yet.)
Does anyone know what the maximum amount of code you can have in a single worksheet in Excel 2003 is?
And is there an easy way to find out how much code you have in a worksheet?
Thanks in advance for your help.
Bookmarks