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
|