| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to paste chart format in vba excel2010
Hello,
I try using John Mansfield's code, but in Excel2010, all the template chart seems to be copied (series are added) . Please advise Sub Copy_Chart_Formats() Dim Sht As Worksheet Dim Cht As ChartObject Application.ScreenUpdating = False ActiveChart.ChartArea.Copy For Each Sht In ActiveWorkbook.Worksheets For Each Cht In Sht.ChartObjects Cht.Chart.Paste Type:=xlFormats Next Cht Next Sht Application.ScreenUpdating = True End Sub Thanks Avi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Problem with FTP commands in Win7+Excel2010 (VBA) | Excel Programming | |||
| Where to put / register a 3rd-party activeX component for use in Excel2010 | Excel Programming | |||
| Copy Paste Chart format in Excel 2003 using VB.NET | Charts and Charting in Excel | |||
| Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming | |||
Linear Mode
