Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Chart doesn't print w/worksheet but will print by itself | Charts and Charting in Excel | |||
Chart doesn't print w/worksheet properly but will print by itself | Excel Discussion (Misc queries) | |||
Print a chart with worksheet data in excel 2007 | Excel Discussion (Misc queries) | |||
How can I print a chart worksheet on legal size paper? | Charts and Charting in Excel | |||
Print Chart Worksheet | Excel Programming |