Moving a variable number of Sheets to another Workbook

  • Thread starter Thread starter Nelson M
  • Start date Start date
N

Nelson M

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!
 
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)
 
Back
Top