Hi everyone,

I have code thats working well for my excel table. Only things I need to modify, is when I clear my search box, it doesn't return empty cells and rows.

I want thats when I clear my searchbox, all the empty rows in my table will also return visible. Now it hides the empty cells after search. Also if possible, I also want that my search goes to second field.

Heres the code:

Private Sub hakubox_Change()

Application.ScreenUpdating = False

ActiveSheet.ListObjects("Data").Range.AutoFilter Field:=1, Criteria1:="*" & [J2] & "*", Operator:=xlFilterValues

Application.ScreenUpdating = True

End Sub
Thanks for everyone!