List Worksheets in Workbook

  • Thread starter Thread starter engimommy
  • Start date Start date
E

engimommy

I am trying to find a way to list all the sheets in a wookbook to use i
a macro ...
Any ideas??:confused
 
I found a handy little utility from ASAP.com (a free download) - i
lists all sheets on one sheet.

The sheet names are all clickable, but it only takes a moment to cop
and paste them as value
 
''list of sheet names in a workbook - placed on a new worksheet
Sub ShowNames()
Set wkbkToCount = ActiveWorkbook
iRow = 1
With Sheets.Add 'ActiveSheet
For Each ws In wkbkToCount.Worksheets
.Rows(iRow).Cells(1).Value = ws.Name
iRow = iRow + 1
Next
End With
End Sub

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

share workbook is greyed out 1
How to save each tab as a new workbook 6
Excel - VBA - workbook/worksheet navigation 1
getting rid of the second wookbook version 3
moving a worksheet..? 2
sorting in a shared wookbook 1
Macro that will hidden columns, rows and worksheets based on an identifier 2
Deleting data but keep formulas/formatting. 3

Back
Top