Is there an object containing the sheet names for a workbook

[Niklas M]

Hi,
here's the problem.
I have worksheets containing the same kind of data and would like to
consolidate data from the sheet with some restrictions. And I would like
construct some sort of macro for this task since it will be repeated quite
often. But the set of sheets in the workbook will probeably change over time.
Is there a method for finding the names of the sheets in an workbook so that
a could loop over the existing sheets?

/Niklas

 

[Gary''s Student]

Sub saysheet()
For Each sh In Worksheets
MsgBox (sh.Name)
Next
End Sub

 

[Bob Phillips]

There is also Worksheets.Count that tells you how many worksheets, or
Sheets.Count that tells you the number of sheets (worksheets, charts, etc.)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)