Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can Excel list all of a workbook's worksheets on a worksheet?
I'd like to get a list of all worksheets in a workbook so I can then
construct links to the same cell in each sheet. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can Excel list all of a workbook's worksheets on a worksheet?
hi bob
Try this macro to create the links for you http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm " m wrote in message ... I'd like to get a list of all worksheets in a workbook so I can then construct links to the same cell in each sheet. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can Excel list all of a workbook's worksheets on a worksheet?
Private Sub ListSheets()
'list of sheet names starting at A1 Dim rng As Range Dim i As Integer Worksheets.Add(After:=Worksheets(Worksheets.Count) ).Name = "List" 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 Wed, 2 Apr 2008 12:43:01 -0700, m wrote: I'd like to get a list of all worksheets in a workbook so I can then construct links to the same cell in each sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking text to external workbook's sheet | Excel Discussion (Misc queries) | |||
easy way to Consolidate Data within workbook's various worksheets | Excel Worksheet Functions | |||
Copy from different workbook's worksheet into a single worksheet... | Excel Discussion (Misc queries) | |||
Create a list in one worksheet of the other worksheets' names | Excel Worksheet Functions | |||
Function to List an Excel Workbook's Sheet Names | Excel Discussion (Misc queries) |