Add the name of each visible worksheet to an array.

[111StepsAhead]

I am attempting to read each worksheet that is visible into an array but can't get the syntax. If anyone can show me the proper syntax or even find a more efficient method than I am using and will show me I'd appreciate it.

Please Login or Register  to view this content.

Everything is declared properly. I just don't know how to test if a worksheet is visible or not.

I have tried

If ws.Visible
If ws.Visible = True
If ws = xlSheetVisible


Thanks in advance for any help.

[mrice]

Visbility has three options.

xlSheetVisible
xlSheetHidden
xlSheetVeryHidden

The final one can only be unhidden by code.

Syntax like...

Please Login or Register  to view this content.

[111StepsAhead]

The options you showed me also did not work. I appreciate the effort though.

The sheets will either be xlSheetVisible or xlSheetVeryHidden. So to add to the list of what doesn't work...

If ws.Visible = xlSheetVisible
If ws.Visible <> xlSheetVeryHidden

In all cases I am simply increasing iCount by 1 or trying to. Each time it counts to 16 (the number of sheets I have.)

[Chance2]

How about this code?

Please Login or Register  to view this content.

[snb]

or

Please Login or Register  to view this content.