| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Print list of ws names
Thanks Chuck
I appreciate your efforts Joanne CLR wrote: Don't remember who in the group gave this to me, but it works good....... Sub ListSheets() 'Lists all SheetNames in Workbook on new sheet called "SheetNames" On Error Resume Next Sheets.Add.Name = ("SheetNames") For i = 1 To Worksheets.Count Cells(i, "a") = Sheets(i).Name Next i End Sub Vaya con Dios, Chuck, CABGx3 "Joanne" wrote: Is there a way in Excel 2003 to print out the names of all the worksheets in my workbook? Thank your for your help Joanne |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Print list of ws names
Is there a way in Excel 2003 to print out the names of all the
worksheets in my workbook? Thank your for your help Joanne |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Print list of ws names
Hi Joanne,
Look at this discussion: http://groups.google.com/group/micro...58779cf90a9 b Note that the link may be split over more lines; paste them in one line in your browser -- Kind regards, Niek Otten Microsoft MVP - Excel "Joanne" wrote in message ... | Is there a way in Excel 2003 to print out the names of all the | worksheets in my workbook? | Thank your for your help | Joanne |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Print list of ws names
Don't remember who in the group gave this to me, but it works good.......
Sub ListSheets() 'Lists all SheetNames in Workbook on new sheet called "SheetNames" On Error Resume Next Sheets.Add.Name = ("SheetNames") For i = 1 To Worksheets.Count Cells(i, "a") = Sheets(i).Name Next i End Sub Vaya con Dios, Chuck, CABGx3 "Joanne" wrote: Is there a way in Excel 2003 to print out the names of all the worksheets in my workbook? Thank your for your help Joanne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Print Name's list and Names Range? | Excel Worksheet Functions | |||
| Can I print a list of names of all the tabs in xls on one page? | Excel Discussion (Misc queries) | |||
| create a random list of names from a list of names in EXCEL | Excel Worksheet Functions | |||
| how do i print a list of names and dates in excel into a two-colu. | Excel Discussion (Misc queries) | |||
| How do I print a list of worksheet tab names in a workbook | Excel Worksheet Functions | |||
Linear Mode
