View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vadhimoo Vadhimoo is offline
external usenet poster
 
Posts: 10
Default 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.