Moving a worksheet to a new workbook when you do not know the name of worksheet

  • Thread starter Thread starter Fireworks99
  • Start date Start date
F

Fireworks99

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.
 
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???
 
Sheets(Array(ThisSheetName, "Attribute Definitons")).Move

Maybe you misspelled "Attribute Definitons" (Definitions ?)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
VBA moving a worksheet to another Workbook 7
Assigning a worksheet name to a variable 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Move multiple worksheets to a new workbook 4
Reference a workbook level named variable. 8
Copy Worksheets To New Workbook 2
How do you capture the name of the current worksheet in VBA? 12

Back
Top