Hide rows that contain text

[Buskopan]

Hello! First of all thanks for useful website.

Need your help. I got spreadsheet with information in columns A to BL and In column "BK" on some rows i got message "closed" the rest within "BK" are with no text in it.

I need macro to hide the columns that contains "Closed" and something that will unhide them if required.

I will set that on the button.

Thank you in advance.

 

[Buskopan]

We did macros for one column BK to separate Closed raws and

What if I have formula in BJ column which checks cell BB for presence of any number and displays Ok or Del (Delay) and I want that filter to work with macro to sort out all "Del"s (Delayed payment in that case)

I have tried to use code.

Sub Hide_Rows_Closed()  With Range("BJ1", Range("BJ" & Rows.Count).End(xlUp))
    .AutoFilter Field:=1, Criteria1:="<>Ok"
  End With
End Sub

But seems I'm doing something wrong here. Or presence of another filter causes nothing to happen.

 

[Buskopan]

Solved. Thank you