15 MB of Heap Space Too Much For Excel?
 

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!

15 MB of Heap Space Too Much For Excel?
 

It seems a few people have recently come across memory problems for no
apparent reason. Whilst I'm not sure what the 14.5MB actually refers to or
how accurate it is, I doubt it is out by a factor of 10.
What about pivot tables ? Apart from that, not sure what you can do.

NickHK

"MDW" wrote in message
...
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!