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.

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

--
Gary''s Student - gsnu200751


"carl" wrote:

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.

Sheets(Sheets.Count).Select

"carl" wrote:

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.

One way:

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


In article ,
carl wrote:

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.