| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a graph and use the data in the new worksheet? | Charts and Charting in Excel | |||
| copy graph from a Worksheet based on a field in another Worksheet | Excel Worksheet Functions | |||
| Copy and Paste Chart as Picture into another workbook or worksheet | Charts and Charting in Excel | |||
| How do I get/copy the (same) layout from a linked worksheet? | Excel Worksheet Functions | |||
| VBA to copy a worksheet to word as a picture | Excel Programming | |||
Linear Mode
