Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

Add.Chart

Posted by JC on May 30, 2001 9:27 AM

I am using
Add.chart
Command
After I am finished creating, setting ranges, sizing and displaying the chart. I went to continue my program, but when it runs it seems to be stuck in the chart mode.
If I say use a comand like
Cells(1,1).select
I seem to get stuck.
How do I get out of the chart mode?

Re: Add.Chart

Posted by Russell on May 30, 2001 9:57 AM

I think you probably need to select a sheet first. Before the Cells.Select line, put a line like:

Worksheets("SheetName").Activate

Hope it works!
______________________________

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.