64kB limit error
I am working on an Excel 97 application does that a great deal of VBA
processing. (The application should've been done in Access, but time and
budget constraints made Excel the tool of choice.) When I try to run one of
the procedures that I just added some more code to I get an error message
I've never seen before. "When compiled procedure exceeds 64kB memory
limitation....." is my approximation of the error response. I don't get
this message on my development machine, but I do on the machine where this
application is normally used.
I assume I have to break the procedure into smaller chunks to rectify this
issue; however, I would like to know a little more about the condition
before I just put a bandaid on it and send it back out.
I could not find anything on the MS website or via searches in some of the
news groups I know of. If someone has addressed thid issue before, please
send me a link to the resource/s.
Thanks in advance.
|