Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. Thanks! :oD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find "Cancellation" in column "A" and copy all data from Columns B-F onto another Sheet | Excel Programming | |||
Display "Activate" dialog from sheet navigation context menu | Excel Programming | |||
Change default in input box from "20" to "000000"? Have macro continue on to name sheet tab? | Excel Programming | |||
Prevent code in "Sheet Activate" from running when sheet made visible from other macr | Excel Programming | |||
Please add a "sheet" function like "row" and "column" functions | Excel Programming |