Thanks Rowan,
I've discovered that the problem was simply an incorect reference to a
dynamic name range. Once I fixed the named range, the message has gone
for good - my sheet has got much bigger without a problem.
Seems that "Not Enough Memory.." also means "check your dynamic name
references"
Cheers
G
Rowan wrote:
There is some info on Excel memory usage he
http://www.decisionmodels.com/memlimits.htm
Hope this helps
Rowan
wrote:
Hi,
I have a system with 1 GB RAM and a 3GHz processor. There are no other
applications open and I've just rebooted.
I've just developed a sheet with about 20 dynamic named ranges that
refer to static range names, like the following:
=OFFSET(OFSP_ACT1,1,0,COUNTA(LIST_ACT1),1)
When I try to load the dyntamic ranges into a comboboxes on a userform,
I'm getting a "run-time error: '70' Not enough resources to display
completely" and "permission denied".
In the Windows Task Bar I see that the Peak Commit Charge I have is
800,000K, compared to a Limit of 2,500,000 K.
Any ideas much appreciated...
G