Hi all,

I've currently got a sub linked to a cmd button that goes through a spreadsheet and checks each row to check if there is a value in T column or if it is blank. If it isn't blank, it hides the line.

Sub Hide_Invoiced()
    For i = 500 To 4 Step -1
        If Len(Cells(i, 20)) <> 0 Then
            Cells(i, 20).EntireRow.Hidden = True
        End If
    Next
End Sub
The problem is that as more and more rows are added;
a) I need to increase the integer it goes from (was 100, then 250, currently 500 but will need to be upped again soon.
b) the time it takes the sub to run is increasing (currently ~20secs)

Is there a more efficient way of carrying this out?

Thanks in advance!