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!
|