Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a list (Word) of the names on Excel worksheet tabs
I need to create a list in Word of the names on (20) Excel worksheet tabs. I
can find the list, but I cannot copy and paste. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a list (Word) of the names on Excel worksheet tabs
See PUP at http://j-walk.com/ss/pup/pup6/
There is a utility for creating a "Contents Page" This creates a list of named worksheets and adds hyperlinks. Regards Phil "PT" wrote: I need to create a list in Word of the names on (20) Excel worksheet tabs. I can find the list, but I cannot copy and paste. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a list (Word) of the names on Excel worksheet
Here is code that will make the list on Sheet1 starting at cell A1. You
probably don't want to remove sheet1 from the list Sub GetWorksheetNames() RowCount = 1 For Each MyWorksheet In ThisWorkbook.Worksheets Worksheets("Sheet1").Range("A1").Offset(rowOffset: =RowCount, columnOffset:=0) = MyWorksheet.Name RowCount = RowCount + 1 Next MyWorksheet End Sub "Philip J Smith" wrote: See PUP at http://j-walk.com/ss/pup/pup6/ There is a utility for creating a "Contents Page" This creates a list of named worksheets and adds hyperlinks. Regards Phil "PT" wrote: I need to create a list in Word of the names on (20) Excel worksheet tabs. I can find the list, but I cannot copy and paste. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a list (Word) of the names on Excel worksheet tabs
I would first put the list into a new worksheet then copy the list to Word.
Private Sub ListSheets() 'list of sheet names starting at A1 'first insert a new worksheet Dim rng As Range Dim i As Integer Set rng = Range("A1") For Each Sheet In ActiveWorkbook.Sheets rng.Offset(i, 0).Value = Sheet.Name i = i + 1 Next Sheet End Sub Gord Dibben MS Excel MVP On Fri, 23 Feb 2007 04:54:31 -0800, PT wrote: I need to create a list in Word of the names on (20) Excel worksheet tabs. I can find the list, but I cannot copy and paste. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
Create a list in one worksheet of the other worksheets' names | Excel Worksheet Functions | |||
create a list of worksheet names (from a single folder, or open files) | Excel Discussion (Misc queries) | |||
How can Excel create a list of tabs on a worksheet? | Excel Discussion (Misc queries) |