Hi/Hoi Ron

BTW: How can i create a workbook with 2 sheets?
You must use SheetsInNewWorkbook

I go install a Dutch 97 version now to test it for you

I be back



--
Regards Ron de Bruin
http://www.rondebruin.nl


"ROn..." wrote in message ups.com...
Hi Rob,

The error message translated from dutch error msg:

Error 1004

Method 'Sheetsinnewworkbook' from object '_Application' failed

Your option

Set wbTarget = Workbooks.Add(xlWorksheet)

works. Tnx!

Gr. ROn...

BTW: How can i create a workbook with 2 sheets?