dim ws as worksheet
for each ws in activeworkbook.worksheets
' you may want to test to see if the worksheet is visible
ws.activate
' put your code here
next ws


"Karen" wrote:

How do you write a VB code to select all worksheets in a file when you don't
know the number of worksheets or the name of the worksheets?

Thanks for any and all help.

Karen