d4vem
08-22-2006, 11:32 AM
Hi all hope someone can help!
This is the most bizarre thing I have ever seen in Excel.
What I am am doing is deleting existing charts (run from the last time) reading a range of cells and creating new charts for each range by person. However I keep getting random errors when I first run it then it will work and then it will fail I have not changed any code between running each time.
After running the macro a given number of times Excel bombs out and crashes I'm not sure if it may to do with the Chart naming convention each time a chart is created but I am changing the parent name each time a chart is added.
Is it some sort of Excel logic thats causing the problem?
I have attached the file just click on the button in Sheet1 the charts will be created in Sheet2 with the colours specified in the Data Colour Table sheet
Thanks in advance of any solution
This is the most bizarre thing I have ever seen in Excel.
What I am am doing is deleting existing charts (run from the last time) reading a range of cells and creating new charts for each range by person. However I keep getting random errors when I first run it then it will work and then it will fail I have not changed any code between running each time.
After running the macro a given number of times Excel bombs out and crashes I'm not sure if it may to do with the Chart naming convention each time a chart is created but I am changing the parent name each time a chart is added.
Is it some sort of Excel logic thats causing the problem?
I have attached the file just click on the button in Sheet1 the charts will be created in Sheet2 with the colours specified in the Data Colour Table sheet
Thanks in advance of any solution