Charts.add ???

BarrettM · Mar 26th, 2002, 07:04 AM

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

DMeador52 · Mar 26th, 2002, 07:11 AM

Check that you have the sheet where the chart goes activated.

Like

ChartSheet.Activate
ChartSheet.Charts.Add

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 26th, 2002, 07:04 AM	#1
BarrettM Board Regular Join Date: Mar 2002 Location: Northern Ireland Posts: 113	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

Mar 26th, 2002, 07:11 AM	#2
DMeador52 New Member Join Date: Mar 2002 Posts: 32	Check that you have the sheet where the chart goes activated. Like ChartSheet.Activate ChartSheet.Charts.Add