This is from Excel VBA help:

Before Optional Variant. An object that specifies the sheet before which
the new sheet is added.
After Optional Variant. An object that specifies the sheet after
which the new sheet is added.
Count Optional Variant. The number of sheets to be added. Teh default
value is one.
Type Optoinal Variant. Specifies sheet type. Can be on of the
following XlSheetType constants: xlWorksheet, xlChart, xlExcel4MacroSheet,
or xlExcel4IntlMacroSheet. If you are inserting a sheet based on an
existing template, specify the path to the template. The default value is
xlWorksheet.


"Jona" wrote in message
ups.com...

Thanks, for the tip. I've tried that and it did give me a hint but
I'm still stuck with the add() function.

I really don't know what to put into this function... any ideas?
thanks!

this are the parameter that the add() function takes:

ws.Add( const VARIANT &Before, const VARIANT &After, const VARIANT
&Count, const VARIANT &Type );