Shouldn't need it.

When you copy the sheets to the new workbook, the new workbook should become the
active workbook.

(But it won't hurt.)

Chuckles123 wrote:

I added 'newwkbk.Activate' before the SaveAs stmt.
OK?
Chuckles123

--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=570973

--

Dave Peterson