M
miek
I have the following code that falls on it face.
The chart gets built like:
Charts.Add
ActiveChart.ChartType = xlColumnClustered
....
ActiveChart.Location Where:=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
The chart gets built like:
Charts.Add
ActiveChart.ChartType = xlColumnClustered
....
ActiveChart.Location Where:=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