In Excel sheet I had macro for hiding and showing all rows that had a red cell in Column A. It was working well but now hangs. Any clues as to why this is happening and how to get round it?
This below is the Show routine which unhides any row with a red cell in Column A as well as showing Column A.
Thank you for looking, and more so if you can help.
' Unhide_Rows Macro
' Unhides hidden rows & Column A
Application.ScreenUpdating = False
Dim Rng As Range
Dim MyCell As Range
Set Rng = Range("A2:A600")
For Each MyCell In Rng
If MyCell.Interior.ColorIndex = 3 Then
MyCell.EntireRow.Hidden = False
Range("A:A").EntireColumn.Hidden = False
Application.ScreenUpdating = True