Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 309
Default Get sheet by index?

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??


  #2   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
dragging the row contents of all the sheet to a Index sheet Narnimar Excel Discussion (Misc queries) 2 December 20th 08 06:04 PM
How to make the sheet index name same as the sheet name after inserting sheets? [email protected] Excel Programming 2 October 26th 07 04:34 PM
Index Max Off other sheet Javier Diaz Excel Worksheet Functions 0 June 6th 07 08:36 PM
Create an Index Sheet Nigel Excel Programming 2 October 21st 05 11:58 PM
Index/Contents Sheet philiphales Excel Discussion (Misc queries) 2 September 9th 05 08:58 AM


All times are GMT +1. The time now is 08:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"