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