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 |
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 |
All times are GMT +1. The time now is 01:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com