|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 28th 12, 08:56 AM
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 
|
| Ads |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Problem with FTP commands in Win7+Excel2010 (VBA) | Lars Thomsen | Excel Programming | 5 | February 18th 12 05:24 PM |
| Where to put / register a 3rd-party activeX component for use in Excel2010 | Heinz-Guenter Lamy | Excel Programming | 1 | June 20th 11 01:05 AM |
| Copy Paste Chart format in Excel 2003 using VB.NET | MacAndy | Charts and Charting in Excel | 1 | May 28th 07 02:14 PM |
| Lock Cell Format - Allow copy and paste of data without format change | Chris12InKC | Excel Worksheet Functions | 1 | March 11th 06 04:44 AM |
| Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | No Name | Excel Programming | 0 | May 3rd 04 12:22 PM |
Linear Mode
