Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i list the names of all my worksheets
is there a way of listing all my worksheets on a master worksheet?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i list the names of all my worksheets
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" wrote in message ... is there a way of listing all my worksheets on a master worksheet? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i list the names of all my worksheets
"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 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List of property names and values for a given object. | Excel Worksheet Functions | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
List of repeating names | Excel Worksheet Functions | |||
Setting up a random list from long list of names ? | Excel Discussion (Misc queries) |