Wanting to select active sheet and one other, then move to new file

[Christopherdj]

Hi - I have the following code, but want to select the "active" sheet and the "lookups" sheet to copy and move to a new workbook.

Because the "active sheet" name changes, it won't always be "XYZ123" hence the need for the active sheet.
The code below is a start, but will need to be amended so it selects the "active sheet" and the "lookups sheet", and creates a New Workbook, that will solve my problem.
thanks.

Please Login or Register  to view this content.

[nilem]

Hi Christopherdj,
try it

Please Login or Register  to view this content.

[Christopherdj]

Oh silly me, that was so obvious. Thank you for the assist, I've got my code now working as required, that activesheet code solved the problem.