Did it Work?

The statement
ActiveSheet.ChartObjects("MyChart").Activate

Is not needed to print the chart. You are printing a sheet
(ActiveSheet.PrintOut) not the object on the sheet. To find the name of the
Chart Object Manually Activate the chart with the mouse and look at the box
left of the f(x).

"Joel" wrote:

Check to make sure the Chart Sheet Tab on the bottom of the sheet matches the
code. Excel renames charts after the Adds statement.

A chart has one name when its created with the ADD and then changes names
when the location statment is executed. I've seen this happen with excel
2003.

"miek" wrote:

I have the following code that falls on it face.
The chart gets built like:

Charts.Add
ActiveChart.ChartType = xlColumnClustered
....
ActiveChart.Location Whe=xlLocationAsNewSheet, Name:="MyChart"

When I try to print with the below code I recieve a Run-time error 1004
"unable to get the chartobject propertyof the ws class" on the .Activate line

ActiveSheet.ChartObjects("MyChart").Activate
ActiveSheet.PrintOut

Thanks for your help