Hi
1. for sorting worksheets automatically check out
http://www.cpearson.com/excel/sortws.htm
2. to get the number of worksheets in a workbook you can use code like this
sub shownumsheets()
MsgBox ActiveWorkbook.Worksheets.Count
end sub
..... to use this code, right mouse click on a sheet tab, choose view code
choose from the menu of the VBE window
insert / module
copy & paste the code on the right hand side of the screen
press ALT & F11 to get back to your workbook
choose tools / macro / macros
click on
shownumsheets and press RUN
--
Cheers
JulieD
check out
www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Balaji's" wrote in message
...
I am balaji i had some querry in excel 2002.
1. how to arrange a worksheet in a excel 2002 workbook?
2. how to know no of worksheet in workbook ?