Find and highlight its matching row using vba

[agasi]

How can this be done using vba?

If range(" G1").value="To be deleted", go and find its FIRST matching row in the table based on same values in columns a,b,c,d.

 

[Perpa]

How can this be done using vba?

If range(" G1").value="To be deleted", go and find its FIRST matching row in the table based on same values in columns a,b,c,d.

agasi,

This code finds the row and SELECTS that row in columns A, B, C, & D:
You can change SELECT to DELETE.
Perpa

Sub MatchingRow()
Dim c As Range
Dim lr as Integer

lr = Range("D" & Rows.Count).End(xlUp).Row
   With Sheets("Sheet1").Range("A2:D" & lr)
       Set c = .Find(What:=Cells(1, "G"), LookIn:=xlValues, LookAt:=xlWhole)
       rw = c.Row - 1
       If Not c Is Nothing Then .Range("A" & rw & ":D" & rw).[COLOR=#ff0000]Select[/COLOR]
   End With
End Sub

Excel 2007

	A	B	C	D	E	F	G
1							25
2
3
4				12
5				15
6				17
7				25
8				15
9				12
10

<tbody>
</tbody>

Sheet1​

 

[agasi]

Perpa
thanks. I have just seen your reply. Hmm, I am not sure it is the one I was looking for. Anyway, I am using another approach using same colours, which I have just posted another question.