Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |