Hi!
I need a little bit help with a macro. In column A i got several projects and if the cell value is "aaa", then I want to hide the row. The projects will always be in row 4 to 703. I have a macro thats working but is super slow so maybe you can help with some smarter way to solve this. My macro right now is:

Sub ActiveProjectandSections()
Application.ScreenUpdating = False

Set rng = Range("A4:A703")
For Each cell In rng
If cell.Value = "aaa" Then
cell.EntireRow.Hidden = True
End If
Next cell
Application.ScreenUpdating = True

Sincerely,
Niclas