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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!