"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