View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Moving a variable number of Sheets to another Workbook

ActiveWorkbook.Charts.Move After:=Workbooks(1).Sheets(1)

--

Regards,
Tom Ogilvy

"Nelson M" wrote in message
...
I am creating a variable number of ChartSheets with VBA
Code. After creating them, I want to move them to
another Workboook. I can't figure out how to refer to
the Array of Sheets so tha I can move them. Any ideas?

Thanks!