VBA Find & Replace

[normpam]

I've read about using 'Range' instead of 'Cell.Replace' in order to get Excel VBA not to replace all cells; only the ones selected, but having trouble with the syntax. How can I fix the following?

Much thanks!

Range("C2", Range("C2").End(xlDown)).Select
Cells.Replace What:="card", Replacement:="Gift card", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2

 

[Fluff]

How about

Range("C2", Range("C2").End(xlDown)).Replace What:="card", Replacement:="Gift card", LookAt:=xlPart, _
       SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
       ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2

 

[normpam]

How about

Range("C2", Range("C2").End(xlDown)).Replace What:="card", Replacement:="Gift card", LookAt:=xlPart, _
       SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
       ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2

Think that does it.. much thanks! (Was running out of time to play with the syntax!)

 

[Fluff]

You're welcome & thanks for the feedback.