simora
10-23-2020, 01:42 PM
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
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