Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Vb macro stops when I try to create more than 89 charts
I created an Excel2002 VB macro that manipulates some data in different ways
then it creates charts of the certain parts of data that I extracted. Every time when the macro is trying to create the 90th chart the macro stops (the VB Editor still says that the macro is running but nothing happen). When I press the pause or the stop button the Excel closes without any warning. Is there a limitation on how many charts I can create, or is something to do with my computer memory (and if that is the problem any suggestions on how to re-write the procedures to manage the memory better?) I have WIN XP S2 with Intel P M 1500MZ with 598Mhz, 512MB of RAM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a Macro that will copy the rows that have a value < 0 | Excel Discussion (Misc queries) | |||
how to create automatic macro with if statement or similar | Excel Discussion (Misc queries) | |||
I want to create 4 pie charts in a line | Charts and Charting in Excel | |||
Create a button to continue old macro execution | Excel Discussion (Misc queries) | |||
Copy CHarts using a MACRO | Charts and Charting in Excel |