USE KEYBOARD TO SELECT ALL SHEETS

E

enos newt gribble

How can I use the key board to select all sheets. I have about 91 sheets
renamed and can't get MACRO to work well. I do change sheet names frequently
and don't want to edit a macro every time I do.
 
D

Die_Another_Day

In the macro use the Sheet Indexes to select:
Sheets(1) 'First Sheet
Sheets(Sheets.Count) 'Last Sheet

Charles
 
G

Gord Dibben

CTRL + Pageup until you get to first sheet.

CTRL + SHIFT + PageDown until all are selected.

If you hold all three keys down continuously you will quickly get to sheet91


Gord Dibben MS Excel MVP

On Tue, 22 Aug 2006 09:56:02 -0700, enos newt gribble <enos newt
 
Top