Adding Worksheets
Try this:
Set NewSheet = ActiveWorkbook.Sheets.Add
NewSheet.Name = "Results"
Regards,
Patricia
-----Original Message-----
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
.
|