ActiveSheet properties

[PapaSmurf]

I am trying to get the number of the active sheet.
eg.
Activesheet.name would produce "Sheet2"

I just want the number of the sheet so that i can select the previous sheet using;
Sheets(1). select

Thanks

 

[Norie]

I'm not 100% sure what you mean but you can get the sheets's index like this.

ActiveSheet.Index

and you can get it's code name like this

ActiveSheet.CodeName

 

[Zack Barresse]

Hi PapaSmurf, welcome to the board!

How about this for selecting the previous sheet ...

On Error Resume Next
Sheets(ActiveSheet.Index - 1).Activate

You would need the On Error Resume Next statement if you were on sheets(1) when you ran this code. You could make it so that it would loop to the last sheet, and vice versa with the last sheet going to the first. If you'd like ..

 

[Norie]

If you just want to activate the previous sheet.

ActiveSheet.Previous.Activate

 

[PapaSmurf]

Thanks Index was the word I was after