Excelerate-nl:
copy graph month
e.g.
Sheets("Sheet1").ChartObjects("Chart 1").Select
ActiveChart.CopyPicture _
Appearance:=xlScreen, Size:=xlScreen, Format:=xlPicture
Sheets("Sheet2").Activate
Range("B10").Activate
ActiveSheet.Paste
--
天行健，君*以自強不息
地勢坤，君*以厚德載物
http://www.vba.com.tw/plog/
"Excelerate-nl" wrote:
Dear Excel expert,
I'm trying to copy some worksheets to a new workbook. The sheets contain
formulas and graphs with references to other sheets. Therefor I would like to
have these references removed, thus copy them as values (but I also need the
same format/layout). The graphs should be copied as pictures to remove the
references.
I have succeeded in removing formula references by the copy - paste as
values methode, but I hope there is another methode. Converting a copied
graph into a picture within Excel doesn't work (only in Word I'm able to
paste it as a picture)
Regards,
jan Bart