I am trying to unhide all hidden rows in a range in ActiveSheet.Range("A4:A93")
For each of those hidden ranges, when it now becomes visible, I want the Cell in Column A once it's now visible / unHidden to be shaded Interior.colorIndex = 19
I'm getting an error in the [PROBLEM] lines, An Object Required Error
I've tried using Row & Cell etc..etc... but I'm still getting an error
For Each Row In ActiveSheet.Range("A4:A93") If Row.EntireRow.Hidden = True Then [PROBLEM] EntireRow.Hidden = False [PROBLEM] EntireRow.Interior.colorIndex = 19