I have a macro that was written in modern day Excel. Sadly, I am trying to share this macro with a friend that has Excel 2013 but it keeps crashing on anything with Selection.Replace.
Is there an easy way to make my code backwards compatible or to know exactly what Excel 2013 doesn't like about the below statement?
Selection.Replace What:="@DC", Replacement:="DC", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=True, FormulaVersion:=xlReplaceFormula2
Thanks!
Bookmarks