SAQIBN
New Member
- Joined
- Oct 16, 2021
- Messages
- 20
- Office Version
- 2013
- Platform
- Windows
Hi
I have following Code for:
Code is as follows:
I have following Code for:
Search from Column C, and delete the If Contains a "Specific word".
but now i want to add more criteria .
like:
if it contains "Roger" or "George" or "Lilly"
then delete those Rows...
Code is as follows:
VBA Code:Sub test() With ActiveSheet .AutoFilterMode = False With Range("d1", Range("d" & Rows.Count).End(xlUp)) .AutoFilter 1, "*Roger*" On Error Resume Next .Offset(1).SpecialCells(12).EntireRow.Delete End With .AutoFilterMode = False End With End Sub