bringing 2 sheets (at the end of workbook) to the Same newly created workbook

Hi,


I Have the last two sheets (which are inserted at the end of a my workbook(MainFile) that I want to move to a new work book.

The issue is I have to move them one by one and the new book that is created --well the name changes--So selecting it is difficult.

So far I have..

Please Login or Register  to view this content.

but can't figure a clever way to select the new workbook created

Any help?

Perhaps make the new workbook the activeworkbook before running the code?

Please Login or Register  to view this content.

Originally Posted by JOHN H. DAVIS

Perhaps make the new workbook the activeworkbook before running the code?

Please Login or Register  to view this content.

Will this rip the Last Two sheets into the workbook?

Don't know what you mean by rip. It will copy them.