I need to be able to define Sheets without knowing there name.

[thedryden]

I have a workbook (well actually a LOT of workbooks) with sheet names that correspond to a day (i.e. 09-05-06). There are 7 sheets per workbook, one for every day of the week. I'm trying to design a Macro to count the number of Yes and No's in the different columns on all seven of the sheets.

What I'd like to do is somehow determine the names of all the sheets on the spread sheet so I could plug them into an array. Any idea how to do this?

[Excelenator]

I'm not sure why you would need this in the scenario you described. You could simply reference the worksheets by their index number like this

Worksheets(1), Worksheets(2), etc.

You could also loop through these worksheets without knowing their names like this

Please Login or Register  to view this content.