| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving a worksheet to a new workbook when you do not know the name of worksheet
I am trying to move 2 worksheets from 1 workbook to another where I know the
name of 1 worksheet but only have a variable with the name of the 2nd worksheet. When I try the following..... Sheets(Array(ThisSheetName, "Attribute Definitons")).Move where "ThisSheetName" is the variable, i get a subscript out of range error (9). Anyone have any thoughts on how to get around this? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Moving a worksheet to a new workbook when you do not know the nameof worksheet
I'd guess that you don't have a sheet by that name in the active workbook.
So maybe it's the variables fault (some sort of typo) or maybe you changed workbooks??? Fireworks99 wrote: I am trying to move 2 worksheets from 1 workbook to another where I know the name of 1 worksheet but only have a variable with the name of the 2nd worksheet. When I try the following..... Sheets(Array(ThisSheetName, "Attribute Definitons")).Move where "ThisSheetName" is the variable, i get a subscript out of range error (9). Anyone have any thoughts on how to get around this? Thanks in advance. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Moving a worksheet to a new workbook when you do not know the name
Sheets(Array(ThisSheetName, "Attribute Definitons")).Move
Maybe you misspelled "Attribute Definitons" (Definitions ?) -- urkec |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help moving a worksheet to another workbook. | Excel Discussion (Misc queries) | |||
| Link worksheet totals to a summary worksheet in the same workbook | Excel Worksheet Functions | |||
| e-mailing a single worksheet of a multiple worksheet (4) workbook | Excel Programming | |||
| How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
| moving worksheet to another workbook | Excel Programming | |||
Linear Mode
