SOLVED excel vba - looping though all worksheets

I need to be able to loop through all the worksheets of a document w/ out knowing the names of the worksheets. Does anyone know how I could go about doing this?

Thanks,
Alex

You get the number of all Worksheets using:

VB Code:

ActiveWorkbook.Sheets.Count

And you can call each of those Sheets using

VB Code:

ActiveWorkbook.Sheets(Number)

works great :)

Thanks for the help

You're welcome, but don't forget to put "solved" in the original topic.