Hello all.
I would like to seek your expertise on this. My code is supposed to replace the word "Template" in my formulas and replace it with "Staff 1". I can't get it to work.
Below is my code. Any help will be greatly appreciated.
Selection.Replace What:="Template", Replacement:="Staff 1", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False