Hide rows if cell in Column E is empty

[annemsauro]

Hello,

I need VBA code that will hide the entire row if a cell in column E is blank.

Please help!!

[TMS]

Why don't you just use Autofilter?

Record a macro while you go through the steps manually.

That should get you most of the way there.

Regards, TMS

[Jakobshavn]

Consider:

Sub HideRows()
Dim rHide As Range, r As Range
Set rHide = Intersect(ActiveSheet.UsedRange, Range("E:E"))
For Each r In rHide
    If r.Value = "" Then
        r.EntireRow.Hidden = True
    End If
Next
End Sub