Navigate between open workbooks
 

I have some code to create a new workbook and paste some data from another.
Buit as i need to do this with several sheets from the original workbook and
add severl sheets to the new workbook,
How do i navigate or SELECT the original workbook again to naviagate to the
other sheets in it?

I have tried:
with workbook("Name").select

and simply

workbook("Name").Select

but i get errors


Any Idea's


CTM

Navigate between open workbooks
 

I have tried:
with workbook("Name").select

and simply

workbook("Name").Select

but i get errors


You just miss the "s", the right instruction a

With Workbooks("Name").Select
Workbooks("Name").Select


FM

Navigate between open workbooks
 

Simple but SO effective.

Thanks


CTM
"FM" wrote in message
...
I have tried:
with workbook("Name").select

and simply

workbook("Name").Select

but i get errors


You just miss the "s", the right instruction a

With Workbooks("Name").Select
Workbooks("Name").Select


FM