I'm trying to insert 2 charts into 2 separate sheets using a macro. My code for 1 graph seems to be fine, but when I introduce the code for the 2nd graph, I either get an excel message box stating that I have not enough memory or else my code has an error at the line: -
charts.add
Has anyony ever come across this before and what would you recommend that I do.
By the way I'm using Excel 97.
Thank you
charts.add
Has anyony ever come across this before and what would you recommend that I do.
By the way I'm using Excel 97.
Thank you