Cannot figure out how to write VBA code to loop through list and Hide specific rows

[vhache]

Hello, I am struggling with creating vba code to loop through attached list and hide each row where the value corresponding to column "D" value is equal "Posting".
The attached is a sample dataset which can contain a few to several (hundreds) rows.

Any help would be greatly appreciated.

[Mumps1]

Try:

Sub HideRows()
    Application.ScreenUpdating = False
    Dim LastRow As Long
    LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
    ActiveSheet.Range("A1:E" & LastRow).AutoFilter Field:=4, Criteria1:="<>Posting"
    Application.ScreenUpdating = True
End Sub