View Single Post
  #1   Report Post  
 
Posts: n/a
Default Dynamic range name problem

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