Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 1st 05, 06:41 PM posted to microsoft.public.excel.worksheet.functions
tmottur
 
Posts: n/a
Default How do I display list of tab names used in a workbook on a sheet

I have a Workbook with 60 named tabs (ie not just Sheet 1, Sheet 2, ...) and
want to have the names appear on a list on a new tab called "Tab Name".

  #2   Report Post  
Old December 1st 05, 06:59 PM posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default How do I display list of tab names used in a workbook on a sheet

Consider this tiny macro:

Sub Macro1()
Dim w As Worksheet
i = 1
For Each w In Worksheets
Worksheets("Sheet1").Cells(i, 1) = w.Name
i = i + 1
Next
End Sub

It assumes that the worksheet "Sheet1" exists to do the recording.

Have a good day!
--
Gary's Student


"tmottur" wrote:

I have a Workbook with 60 named tabs (ie not just Sheet 1, Sheet 2, ...) and
want to have the names appear on a list on a new tab called "Tab Name".

  #3   Report Post  
Old December 1st 05, 09:42 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default How do I display list of tab names used in a workbook on a sheet

Sub ShowNames()
Set wkbkToCount = ActiveWorkbook
iRow = 1
With Sheets.Add
.Name = "Tab Name"
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

On Thu, 1 Dec 2005 10:41:03 -0800, "tmottur"
wrote:

I have a Workbook with 60 named tabs (ie not just Sheet 1, Sheet 2, ...) and
want to have the names appear on a list on a new tab called "Tab Name".




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving one sheet within a workbook David Vollmer Excel Discussion (Misc queries) 2 September 14th 05 06:04 PM
Get other sheet names into a column Keyser Excel Worksheet Functions 2 August 27th 05 02:02 AM
Identify repeated cell entries in multiple sheet workbook as you . Trigger Excel Discussion (Misc queries) 0 August 17th 05 01:57 AM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Pull unique names for drop down list [email protected] Excel Discussion (Misc queries) 3 February 1st 05 10:23 PM


All times are GMT +1. The time now is 09:40 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017