Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
help with dynamic range | Charts and Charting in Excel | |||
Reference to a dynamic range | Excel Discussion (Misc queries) | |||
Add up a Dynamic Range with 2 Variables | Excel Worksheet Functions | |||
Add a Dynamic Range with 2 Conditions Q | Excel Worksheet Functions |