storemannequin
Board Regular
- Joined
- May 29, 2010
- Messages
- 108
I recorded this find & replace with the recorder than added in a variable of my own, but is there a way to do this w/o resorting to the recorder?
Sub ReplaceTitles()
FC = Cells(1, Columns.Count).End(xlToLeft).Column
Set Rng = Range(Cells(1, 1), Cells(1, FC))
With Rng
.Replace What:="Matrix", Replacement:="Overhead", LookAt:= _
xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
.Replace What:="Net ", Replacement:="Catch", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
.Replace What:="Little league", Replacement:= _
"ASP", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, _
SearchFormat:=False, ReplaceFormat:=False
End With
End Sub