Selecting last sheet in workbook

[Guest]

I'm trying to select the last sheet in a workbook. I know that going to the
next sheet is this:

ActiveSheet.Next.Select

But what is the command to select the very last sheet? End and Last don't
work.

 

[Guest]

Sub lastone()
Sheets(Worksheets.Count).Activate
End Sub

 

[Guest]

Sheets(Sheets.Count).Select

 

[JE McGimpsey]

One way:

With ActiveWorkbook.Worksheets
.Item(.Count).Select
End With