Navigate between open workbooks

[Corey]

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

 

[FM]

I have tried:

with workbook("Name").select

and simply

workbook("Name").Select

but i get errors

You just miss the "s", the right instruction are:

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


FM

 

[Corey]

Simple but SO effective.

Thanks


CTM

You just miss the "s", the right instruction are:

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


FM