Compile Error: Named Argument not found

[awesusan]

Hello,

My colleague has recorded a macro which works for 2 of our team.
However when others try to use it they get a "Compile Error: Named Argument not found".

I have done some research and I think I understand what a Named Argument is, but I don't understand how its created or why it works for some and not others.
Here is a section of the code, I have highlighted in blue the section that is highlighted when the error appears:

Range("C6").Select
Cells.Replace What:="Student ", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2
Cells.Replace What:=" has clash:", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2

To use the macro file, it is saved in a shared folder and then individuals copy the file to their desktop before using.

Any advice would be very much appreciated, thank you!

 

[CephasOz]

The problem is caused by your site having different versions of Excel on different computers. The "FormulaVersion" named argument is a recent addition, so older versions of Excel will complain. Delete everything on the line from the comma in front of "FormulaVersion" to the end of the line.