Dear Chris

The below will copy Sheet1, Sheet2 and Sheet3 from open workbook Book1 to
another open workbook Book2 . These 3 sheets will be copied after the first
sheet in Book2. Will that help...

Workbooks("Book1").Worksheets(Array("Sheet1", _
"Sheet2")).Copy After:=Workbooks("Book2").Worksheets(1)

If this post helps click Yes
---------------
Jacob Skaria


"Chris Maddogz" wrote:

I currently have a workbook (call it no name) & via a macro am copying some
worksheets from another workbook to it.

Is there an easy way to copy multiple worksheets from another workbook to
this noname workbook?