View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Selecting last sheet in workbook

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.