Worksheet Selections in Macros

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

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

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

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

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

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