| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find No of sheets ,sheet no
Hi ,
Is there any option to find the no of sheets in the work book and any possible to find the "sheets no" or sheets position for example: In my workbook contains worksheets Traffic2005,Customer,Tax2005,Mar 2006 Instead of using sheets name, i want to use the sheets's no like Traffic2005 - "1" Customer- "2" Tax2005-"3" Mar 2006-"4" Thanks in advance for your reply. Have a nice day. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to find cell content in sheets and make sheet active | Excel Discussion (Misc queries) | |||
| Copy Sheet to new Sheet and clear cells on original sheets | Excel Discussion (Misc queries) | |||
| search all sheets in book to find value and activate sheet with va | Excel Programming | |||
| How to find the type of Sheet in Excel.Workbook.sheets collection | Excel Programming | |||
| Allocate Files to Sheets and Build a Master Sheet which Summarises All Sheets | Excel Programming | |||
Threaded Mode
