Excel VBA Query

[BOAC]

Any VBA gurus please -

I have a macro which works with data from 3 worksheets in a book. I wish to save only worksheets 1 and 2 to a new workbook.

At the moment I save (all 3) with

ActiveWorkbook.SaveAs TITLE

I have had some but not all success with

ActiveWorkbook.ActiveSheet("Sheet1").SaveAs TITLE