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..
Set ThisWorkbook = MainFile
'Find the last sheet
Sheets(Sheets.Count).Select
'Move to New Workbook
ActiveSheet.Move
MainFile.Select 'going back to the mainworkbook to grab the second piece of sheet
'Now trying to grab the last sheet
Sheets(Sheets.Count).Select
but can't figure a clever way to select the new workbook created
Any help?
Bookmarks