Thread: Copying multiple worksheets into a new workbook
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
anhjan[_2_] anhjan[_2_] is offline
external usenet poster
  
Posts: 1
Default Copying multiple worksheets into a new workbook
Thanks guys for the suggestions, however, I'm still getting stuck afte
copying the first sheet to the new workbook. The error I get is tha
it is a "Runtime error '9'; Subscript is out of range" and i
hightlights:

Sheets(DataSheet).COPY After:=wbk2.Worksheet.Count


Any other suggestions..

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote