MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

vb code

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

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.



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.