VBA help hiding rows

[Ada339]

Hello,

I'm looking for a way to automatically hide rows based on cell data.

The rows are 14-900, columns are A - AU and if the data in column AE reads "i. onboarded" I would like the whole row hidden.

is this possible?

Cheers,

 

[JumpingCrab]

Try this:

Sub HideRows()
    Dim cl As Range
    For Each cl In Range("AE14:AE900")
        If cl.Value = "i. onboarded" Then
            cl.EntireRow.Hidden = True
        End If
    Next
End Sub

You can link this to a button or just run the macro directly.

Hope this helps.

JL

 

[Ada339]

amazing! thank you!!

 

[JumpingCrab]

You're welcome. Glad to be of help