Hi Peter

Try ActiveWorkbook.Sheets.Add

Cheers,
Flemming


"Peter" wrote in message
...
Hi

I am creating an Add-in. This Add-in functions will run on
top of a workbook of data. How do I add a new worksheet in
active workbook with the name "Result" from a function in
the Add-In.
I tried the following but it does not work
ThisWorkBook.Sheets.Add

Also how to ensure that it already does not exist

I use Excel 2002 on Win 2000

Please advise
Thanks a lot