I currently have this working, but it has to search a few 1000 rows and it takes a fair while to run. I'm hoping it can work quicker using find but can't work out how to convert it.
if theres a match its normally 5-12 rows that will match
i want to find the rows that contain wsSource.Range("C3").Value in wsDest column A
on a match delete the matched row then look for another match.
if theres a match its normally 5-12 rows that will match
i want to find the rows that contain wsSource.Range("C3").Value in wsDest column A
on a match delete the matched row then look for another match.
VBA Code:
Dim i As Long
With wsDest
For i = wsDest.Range("A" & Rows.Count).End(xlUp).Row To 1 Step -1
If wsDest.Cells(i, 1) = wsSource.Range("C3").Value Then .Rows(i).Delete
Next i
End With