Refering to sheets positioned after current sheet

Hi

Is there a way to find out which worksheets are after the current one (as positioned on the bottom of excel)? I know the move and copy functions use before and after arguments, which gives me hope that maybe there is some property indicating the physical layout of the sheets.

Thanks

See the Next and Previous properties of a worksheet.

Sheet Index, see

http://excel-it.com/SheetName.htm

Thanks to both of you, I was actually thought the Sheet Index name and Sheet Code name were one and the same.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save