help please to find than ""

[scsi5000]

Hallo, Please I need Help :

I make 2 Worksheet first one (database) and second (entry) .What macro can I use to search a tab from (entry) (A1) for the row in the (database) that contains the word "car123" in column C and then clear it ""

thank you

[Oorang]

Public Sub Replace()
Dim rngKeys As Excel.Range
Set rngKeys = ThisWorkbook.Worksheets("Database").UsedRange
Set rngKeys = Excel.Intersect(rngKeys, rngKeys.Columns(1))
rngKeys.Replace What:="foo", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub