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

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

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