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