Hi Bob:

You probably meant ActiveSheet rather than ActiveWorksheet :-).

Regards,

Vasant.

(PS Myrna nailed me for the same mistake a couple of years ago.)


"Bob Phillips" wrote in message
...

"csus_tony " wrote in message
...
hello

how do i create a new worksheet in a workbook using code?


ActiveWorkbook.Worksheets.Add

can i also rename the worksheet

ActiveWorkbook.ActiveWorksheet.Name = "Tony"

and put it in alphibetic order?


See Chip Pearson's site at http://www.cpearson.com/excel/sortws.htm