Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Data between sheets in the same workbook and moving data between Workbooks. | Excel Worksheet Functions | |||
moving data between workbook sheets | Excel Discussion (Misc queries) | |||
Moving Sheets within a workbook | Excel Worksheet Functions | |||
add new sheets in a workbook with new sheets being a variable | Excel Discussion (Misc queries) | |||
Use of variable to identify range of sheets in a workbook | Excel Discussion (Misc queries) |