MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?


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!
______________________________