Thread: COPY CHARTS
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
msnews.microsoft.com[_6_] msnews.microsoft.com[_6_] is offline
external usenet poster
 
Posts: 6
Default COPY CHARTS

Hi,
how do I copy all charts in hidden sheet using a loop, my idea is
display a preview of each chart in a main sheet, and I'd like to use a loop
something like

for each chart in sheet2
chart(x).activate
chart(x).copy
sheet1.select
activesheet.paste
next x

well that's the main idea, any help will be greatly appreciated, thanks !!