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