View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Get sheet by index?

msgbox activesheet.index



Robert Crandal wrote:

If I have many sheets in my workbook, how can I get
the index number of the active sheet?? Is there
a property or method for "ActiveSheet" which gives
back this value??


--

Dave Peterson