Hi guys, I've thrown in the towel looking online for the answer. Im quite basic at this so would really appreciate some help on the below.
I have this code that I found and it searches through data and deletes it when it finds a vlaue that I set. Without copying the code over and over again - is it possible to set the below small amount of code to search for about 4 items or so in stead of just the one.
At the moment it searches for the N1 and if I put in for example N1:N2 I still cant get it to search through for both items i need to finds.
Sub CLIENTOUT()
Dim FoundCell As Range
Application.ScreenUpdating = False
Set FoundCell = Range("A3:A200").Find(what:=Range("N1"))
Do Until FoundCell Is Nothing
FoundCell.EntireRow.Delete
Set FoundCell = Range("A4:A200").FindNext
Loop
End Sub
thanks again for your time
I have this code that I found and it searches through data and deletes it when it finds a vlaue that I set. Without copying the code over and over again - is it possible to set the below small amount of code to search for about 4 items or so in stead of just the one.
At the moment it searches for the N1 and if I put in for example N1:N2 I still cant get it to search through for both items i need to finds.
Sub CLIENTOUT()
Dim FoundCell As Range
Application.ScreenUpdating = False
Set FoundCell = Range("A3:A200").Find(what:=Range("N1"))
Do Until FoundCell Is Nothing
FoundCell.EntireRow.Delete
Set FoundCell = Range("A4:A200").FindNext
Loop
End Sub
thanks again for your time