View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
IanKR IanKR is offline
external usenet poster
 
Posts: 97
Default Sheet navigation, if there isn't hotkey for "go to first sheet"?

I know that there is Ctrl+PageUp + Ctrl+PageDown to navigation/browse
back and forth in a workbook but couldn't find anything via google re
a hotkey to go to first and last sheets. If there isn't anything,
thought that a macro would do.

If no hotkey, thought that something like this might work:

Sub GOto_First_Sheet_in_Workbook()
Sheets("Worksheets(1)").Activate
End Sub

But I don't know how to type in the generic name for the first sheet.
I believe I've used Worksheets(1) in other cases but this isn't
working here and I can't find what to do to go to the last sheet, also
using a generic term rather than a specific sheet name. This way I
can put this into my PERSONAL.xls.


Sub Goto_Last_Sheet_in_Workbook()
Sheets(Sheets.Count).Activate
End Sub


Sub Goto_First_Sheet_in_Workbook()
Sheets(1).Activate
End Sub