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
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