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

Charles

enos newt gribble wrote:
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.