I am trying to write a VBA code that automatically hides rows if a value in the row is equal to "". My range of values is A37:A400. Because my range is so big my previous VbA is to slow and looks one line at a time. Any ideas to make a fast code that will go though this large list and hide rows in a quick fashion. Right now it takes about a minute to hide the rows which is too Long.
Sub HideRows()
Dim cell As Range
For Each cell In Range("A37:A400")
If Not IsEmpty(cell) Then
If cell.Value = "" Then
cell.EntireRow.Hidden = True
End If
End If
Next
End Sub
If Not IsEmpty(cell)
then how doesif Cell.Value
ever get executed?