View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default GO TO LAST SHEET

One way would be to create a Rangename in cell A1 of each of your sheets,
called _Sh1, _Sh2, _Sh3, etc

Then do F5 and select which sheet you want to go to........
The underscores in the above RangeNames is to make them appear at the
beginning of your list of rangenames if you have many.....not needed if you
only have a few rangenames.

hth
Vaya con Dios,
Chuck, CABGx3



"Carolan" wrote:

I have a workbook that has 15 sheets. Is there a quicker way of moving from
Sheet one to Sheet 15 without using the mouse or Ctrl + Page Down ten times??
Something like the "Go To" feature (i.e. Ctrl + G) for working within one
sheet????
--
Carolan