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.
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.
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.
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.
>
>
"Duke Carey" wrote:
> 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.
> >
> > Worked Perfectly! Thanks
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
[email protected]> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks