So, I'm trying to hide rows based on an N/A value and wrote the following code.
For Each c In Sheets("Summary").Range("b5:b5000")
If c.Value = "N/A" Then c.EntireRow.Hidden = True
However, its very slow and takes too much time. Do you have any ideas how I can speed up the process?