Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

vb code

  Asked By: Molly    Date: Sep 01    Category: MS Office    Views: 698
  

I will like to have a vb code that will allow me to select a few sheets in one
workbook and copy them to a new workbook.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Chad Bradley     Answered On: Sep 01

Using the .Copy method without an argument will open a new workbook  and
put the sheets  in it. For instance, this code  copies two sheets from the
open workbook into a new one:

Sheets(Array("Sheet1", "Sheet3")).Copy

 
Didn't find what you were looking for? Find more on vb code Or get search suggestion and latest updates.




Tagged: