Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to auto arrange the worksheet in a excel 2002 file?
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 ? |
#2
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I enable "import text file" excel 2002? | Excel Discussion (Misc queries) | |||
Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel | |||
Despite formatting a column in Excel 2002 worksheet as Short Date. | Excel Discussion (Misc queries) | |||
Copying blank excel worksheet into additional excel workbooks | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |