USE KEYBOARD TO SELECT ALL SHEETS
Faster to just use
activeworkbook.Worksheets.Select
"Die_Another_Day" wrote:
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.
|