Starting yesterday, I've been getting a strange message telling me that
"Excel cannot complete the task with the resources available"....through
various research, I discovered the Application.MemoryUsed function. I've
popped it up at various sections of my code, and it shows that Excel is using
between 8,900,000 and 15,229,000 bytes...this latter number, if my
calculations are correct, translates to around 14.5 MB.
According to the article at
http://www.decisionmodels.com/memlimitsc.htm, my
version of Excel (XL 2003) should have nearly a gig of space before I get any
errors.
So what's going on here?
--
Hmm...they have the Internet on COMPUTERS now!