I have a workbook that has numerous pivot tables and charts. I use the "page" in the pivot table to cycle through all the items in the data to make reports. On each cycle through the pivot data I create a copy using ActiveSheet.Copy to do some cleanup before making a webpage. My problem is that not all of the charts are being copied. Sometimes all the charts are copied and sometimes certain ones are missing. I cannot seem to find a pattern nor figure out why this happens. Any help would be greatly appreciated.
--~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---