travsersing visible sheets

[Luis939]

is there a simpler alternative to

for each ws in worksheets
if ws.visible = true then ....
next

is there something sort of equivalent to

for each ws in worksheets.hidden
next

OR

for each ws.hidden in worksheets
next


thanks

 

[woja]

The simple anser is "no".

The [tt]For Each[/tt] statement works on collections and there is no collection of hidden sheets (i.e., [tt]Worksheets.Hidden[/tt] is not a collection). The "loop variable" is assigned, in turn to each element in the collection (i.e., [tt]ws.Hidden[/tt] is not a variable that you can assign members to).

Your first code fragment is the simplest method.

[tt]________________________________________________________________
Roger
Life is a game of cards in which the deck contains only jokers.[/tt]

 

[Luis939]

oh ok i needed to be reminded that the loop works on collections, thanks

 

[Luis939]

i guess NO is the same answer for the other thread i posted today where i wanted to know if i could traverse just the comments of one column, but i guess i can only do that for a whole worksheet, thanks

 

[xlbo]

Yeah - comments are a bit wierd - the collection belongs to the worksheet but the comment object itself belongs to a range so you can't reference comments in a specific range but you add them to a specific range

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[SkipVought]

Luis
Can't you use the cod that I posted?

    For Each com In Comments
        If com.Parent.Column = 3 Then
        'stuff to do with comments in col C
           
        End If
    Next

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884