VBA: Find Last Worksheet in workbook

[BIGTONE559]

I'm trying to figure out a dynamic way of finding the last sheet in a workbook.

I currently know that the last sheet index=50 however, i want to make the code suitable in the event the last sheet index changes.

Cheers!

 

[Norie]

This will get you the last sheet:

set ws =  Sheets(Sheets.Count)
MsgBox ws.Index & "-" & ws.Name & "-" & ws.CodeName

 

[VoG]

Maybe like this

Worksheets(Worksheets.Count).Select

 

[BIGTONE559]

appreciate the help. both methods worked seamlessly.