Thread: Moving a worksheet to a new workbook when you do not know the name of worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fireworks99 Fireworks99 is offline
external usenet poster
  
Posts: 1
Default 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.

Reply With QuoteReply With Quote