Moving a variable number of Sheets to another Workbook
 

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!

Moving a variable number of Sheets to another Workbook
 

Nelson,

As well as Worksheets, there is a Charts collection.

You can access these through

For Each ch in Charts
Debug.Print ch.Name

or

For i = 1 To Charts.Count
Debug.Print Charts(i).Name

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

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

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!