Chart question in Excel 2003

[jeffiec]

Having problems coding a chart. After Activating the chart and trying to give it a tile, I get errors.

Public Sub loadchart()
Worksheets("Main").ChartObjects(1).Activate
With ActiveChart


End With

works with no problem, when I add the following code I get errors,

Public Sub loadchart()
Worksheets("Main").ChartObjects(1).Activate
With ActiveChart
.HasTitle = true

End With

the error is:
Run-time Error '1004' Method 'HasTitle' of object '_Chart' failed

I have tryed almost every example of the help file and on the web, no luck!
HELP!
Thanks in advance.
Jeff

 

[DRJ]

I believe you will still need to activate the chart. If the chart is already active, no problem, but activate a cell and try to run your macro to make sure it still works.