View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default Looping with Hidden and Protected Sheets/Ranges

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