is there a way of listing all my worksheets on a master worksheet?
is there a way of listing all my worksheets on a master worksheet?
Hi Tthe,
Visit David McRitchie's site and see his Table of Contents page at:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
If you are not familiar with macros, you may wish to visit David McRitchie's
'Getting Started With Macros And User Defined Functions' at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
---
Regards,
Norman
"tthe" <tthe@discussions.microsoft.com> wrote in message
news:A3BFD26A-090A-43C7-95FE-C8C9F21936A1@microsoft.com...
> is there a way of listing all my worksheets on a master worksheet?
"tthe" wrote
> is there a way of listing all my worksheets
> on a master worksheet?
Another option, try the sub below:
Steps
--------
Press Alt+F11 to go to VBE
Click Insert > Module
Copy > paste everything within the dotted lines below
into the whitespace on the right
-------begin vba-----
Sub SheetNames()
'Peo Sjoblom in .worksheet.functions Jul '02
Dim wkSht As Worksheet
Range("A1").Select
For Each wkSht In Worksheets
Selection = wkSht.Name
ActiveCell.Offset(rowOffset:=1, columnOffset:=0).Activate
Next wkSht
End Sub
-------endvba------
Press Alt+Q to get back to Excel
In a *new* sheet, press Alt+F8
Select "SheetNames" > Run
The sheetnames will be listed in A1 down, in this sequence:
1st sheet (leftmost) will be listed in A1,
2nd sheet in A2, and so on
Hidden sheets will also be listed
and will appear after the last (rightmost) sheet
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks