Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I print the names of all the sheets in a list?
I have an exceldokument with 30 sheets and would like to print the names of
the sheets in a list. Someone who knows how that works? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I print the names of all the sheets in a list?
You can try out the below macro. If you are new to macros..
--Set the Security level to low/medium in (Tools|Macro|Security). --From workbook launch VBE using short-key Alt+F11. --From menu 'Insert' a module and paste the below code. --Get back to Workbook. --Run macro from Tools|Macro|Run <selected macro() Sub GetSheetNames() Dim sh As Worksheet, lngRow As Long For Each sh In ActiveWorkbook.Worksheets lngRow = lngRow + 1 Range("A" & lngRow) = sh.Name Next End Sub -- If this post helps click Yes --------------- Jacob Skaria "SUN" wrote: I have an exceldokument with 30 sheets and would like to print the names of the sheets in a list. Someone who knows how that works? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print list of names of all sheets in a workbook | Excel Discussion (Misc queries) | |||
Print list of ws names | New Users to Excel | |||
Can I print a list of names of all the tabs in xls on one page? | Excel Discussion (Misc queries) | |||
how do i set up a list of names on a sheet frm various sheets in e | Excel Discussion (Misc queries) | |||
How do I print a list of worksheet tab names in a workbook | Excel Worksheet Functions |