Copying a chart

L

Linda Mac

I want to copy a chart from one workbook to another. But,
I don't want the second workbook to have links to the
first. Is there a way to copy the chart as a picture or
object?
 
J

JE McGimpsey

Or, since this is the programming group:

ActiveChart.CopyPicture Appearance:=xlScreen, Size:=xlScreen
 
Top