JoeyGaspard
Board Regular
- Joined
- Jul 22, 2019
- Messages
- 147
Hi all, I am using the following code to filter some data and delete it, but I need to put in multiple criteria's, and I am not sure how to do that, please help! The section in bold is where i need to add multiple items.
VBA Code:
With Sheets("Pivot")
.AutoFilterMode = False
With .Range("D", .Range("D" & Rows.Count).End(xlUp))
.AutoFilter 1, "0"
On Error Resume Next
.Offset(1).SpecialCells(12).EntireRow.Delete
End With
.AutoFilterMode = False
End With
Last edited by a moderator: