Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
Paul, would this revision work for you? It assumes you don't need the
reference to the .bmp file to copy the pictu Sub CopyChart() ActiveSheet.ChartObjects("First Chart").Activate ActiveChart.ChartArea.Select ActiveChart.CopyPicture Appearance:=xlPrinter, Size:=xlScreen, Format:= _ xlPicture Range("A31").Select ActiveSheet.Pictures.Paste.Select End Sub ---- Regards, John Mansfield http://www.pdbook.com "Paul Smith" wrote: What on earth is happening with th code below?????? The code works fine, copying a chartobject and pasting it into a new location. The problem is that while the chart area is the same size, only two thirds of the image is copied. I will say that I have stretched the plot area of the original, it itself does not behave strangely. I have no idea what the problem is, does any one else? Code Snippet: ThisWorkbook.Activate Worksheets("Summary").Activate Range("A30").Select ActiveSheet.ChartObjects("First Chart").CopyPicture xlScreen, xlBitmap Workbooks(TargetWB).Activate Worksheets("Summary").Activate Range("A31").Select ActiveSheet.Paste |