How to copy worksheet layout, values and graph as picture
 

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

How to copy worksheet layout, values and graph as picture
 

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