You can't select a hidden sheet. But if you don't try to select or
activate, then hidden sheets shouldn't interfere with the loop structure
itself.

Looping through cells shouldn't be affected by whether they are in a hidden
row or column. Actions you may perform on those cells or with those cells
may have problems, but the best would just be to test the code.

--
Regards,
Tom Ogilvy


"ExcelMonkey" wrote in message
...
I know I can hide sheets in excel. When I am looping through sheets using
a
For Next loop in VBA (using Sheets collection) will I ever run into issues
with sheets that are hidden and or protected? That is, could I ever be in
a
situation where my For Next loop would fail due to hidden/protected
sheets?

I guess the same question extends to cell ranges. If I am looping through
sheets and then cell ranges (For Each cell in .UsedRange) and lets say I
am
assessing formulas/data/text, will hidden row/columns and or protected
cells
cause errors in these sub loops?

Thanks