Hi Everyone,
I really need your help, I already exhausted all resources and done several research on the VBA to copy and paste charts side by side.
I improved on this macro but cant seem to make it work, that is to paste the charts side by side the result is the charts were overlapping.
recCount = 1
Application.ScreenUpdating = False
For Each ws In ThisWorkbook.Worksheets
For Each ch In ws.ChartObjects
ch.CopyPicture xlScreen, xlBitmap
With destWB.Worksheets(2)
.Paste .Cells(recCount * myOffset + 4, 2)
End With
recCount = recCount + 4
Next ch
Could anybody point out what's wrong with the code to make the charts paste side by side?
Appreciate it very much.
Bert
Bookmarks