Select all worksheets

[Jonbob]

I have 200 worksheets in a workbook. What macro is there to select all worksheets?

Thanks,
Jonbob

 

[Jonbob]

I'm not really working on rocket science. I have every Seinfeld script, and wanted to be able to select all the sheets so I can search them all at once.

Splitting the atom,
Jonbob

 

[tusharm]

Thanks for that. And, I assume there is some reason the information won't go into a single table in one worksheet.

You might also want to look at Jan Karel Pieterse' FlexFind add-in available from http://www.bmsltd.co.uk/MVP/MVPPage.asp#JanKarelPieterse

I'm not really working on rocket science. I have every Seinfeld script, and wanted to be able to select all the sheets so I can search them all at once.

Splitting the atom,
Jonbob