Looping through a workbook with sheets and charts

[Masact]

So I'm trying to go through a workbook and, based on some user inputs, hide certain sheets and charts (these charts are their own tab, i.e. a chart object). Here's a sample code I wrote for a dummy workbook I have. Unfortunately it doesn't work, I think because the loops are nested. However if I can figure out how to fix this code I can easily adapt it to my other real problem. Please let me know what I'm doing wrong and/or how I can solve this issue.

Please Login or Register  to view this content.

Is there a way to scan through the workbook in one loop (sheets and charts together)? I think that's what I'm missing here. Thanks!

[Phil_V]

I think what you are looking for here is the use of "Sheets" instead of "Worksheets". I recently came across it when working with charts too.

Looping through "Sheets" includes all the worksheets and all the chart-sheets, whereas looping through "Worksheets" only includes the worksheets

Something like this I think:

Please Login or Register  to view this content.

[Masact]

Thanks, yeah I actually stumbled across that myself earlier when I was trying to fix it. Thanks for your help!

Out of curiosity, how does the Variant property work?