Navigate between open workbooks

  • Thread starter Thread starter Corey
  • Start date Start date
C

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
 
I have tried:
with workbook("Name").select

and simply

workbook("Name").Select

but i get errors
Click to expand...

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

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


FM
 
Back
Top