View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
graloe graloe is offline
external usenet poster
 
Posts: 5
Default How do I generate a list of the tabs/worksheets from a workboo

Yes... thank you so much for responding!

"Gord Dibben" wrote:

No links are created.......just a list of the sheets is returned.

Perhaps you should start a new thread with a better description of what you need
doing?


Gord Dibben MS Excel MVP

On Wed, 23 May 2007 06:06:01 -0700, graloe
wrote:

This sounds very similar to what I need to do... but how did you create the
links to each sheet?

"Gary''s Student" wrote:

Glad I could be of help.
--
Gary''s Student
gsnu200709


"Philip" wrote:

Brilliant! Just what I was looking for! And I didn't even have to ask the questions. Thanks.

Philip

Gary''s Student wrote:
Here is part of your answer. Enter the following macro, then select some
cell and run the macro. It will produce the list of worksheets at the point
you selected:

Sub sheet_lister()
i = 0
For Each w In Worksheets
Selection.Offset(i, 0).Value = w.Name
i = i + 1
Next
End Sub