I have headers in row1 on sheet6
want to delete all rows from row2 onwards where 'Paid' appears in Col P
I have written code to do this, but the headers in row1 are also deleted
It would be appreciated if someone could kindly amend my code so that row1 in not deleted
want to delete all rows from row2 onwards where 'Paid' appears in Col P
I have written code to do this, but the headers in row1 are also deleted
It would be appreciated if someone could kindly amend my code so that row1 in not deleted
Code:
Sub DeletePaidItems()
With Sheets(6).Cells(2).CurrentRegion.Columns(16)
.AutoFilter 1, "Paid"
.EntireRow.Delete
End With
End Sub