Anthony,
If you create the workbook yourself, use Bret's suggestion. However, if you want to add a new sheet to an existing workbook you can use the following code:
*--add a new sheet at the end
loWBook.sheets.add(,loWBook.sheets(loWBook.sheets.count()) )
Daniel