Home |
Search |
Today's Posts |
#1
|
|||
|
|||
view list of worksheets contained within a workbook
how do i view list of worksheets contained within a workbook in excell?
|
#2
|
|||
|
|||
Right click one of the sheet tab arrows at the left hand side
Only other option is to us VBA (macro) -- Regards, Peo Sjoblom "michael" wrote in message ... how do i view list of worksheets contained within a workbook in excell? |
#3
|
|||
|
|||
A macro to list the sheets on a new worksheet.
Private Sub ListSheets() 'list of sheet names starting at A1 Dim Sh As Worksheet Dim Rng As Range Dim i As Integer Worksheets.Add Set Rng = Range("A1") For Each Sh In ActiveWorkbook.Sheets Rng.Offset(i, 0).Value = Sh.Name i = i + 1 Next Sh End Sub Gord Dibben Excel MVP On Tue, 22 Feb 2005 06:31:03 -0800, "michael" wrote: how do i view list of worksheets contained within a workbook in excell? |
#4
|
|||
|
|||
"michael" wrote:
how do i view list of worksheets contained within a workbook in excel? You can also click on "File", drop to "Properties" and then click on the "Contents" tab to see the list of worksheets |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can one print a list of worksheet tab labels contained in a workb. | Excel Discussion (Misc queries) | |||
print a list of worksheets and links | Excel Worksheet Functions | |||
List of Worksheets in a work book | Excel Worksheet Functions | |||
Consolidate list from multiple worksheets | Excel Worksheet Functions | |||
To view different sheets using a drop down list | Excel Worksheet Functions |