Thread: How to write the code for copying 2 or more sheets to a new workbook at the same time?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default How to write the code for copying 2 or more sheets to a new workbook at the same time?
worksheets(Array("Sheet1","Sheet4")).Copy
Activeworkbook.SaveAs "C:\My Folder\abc.xls"
--
Regards,
Tom Ogilvy

"new.microsoft.com" wrote in message
...
As subject, Thanks




Reply With QuoteReply With Quote