A
A.S.
Hello,
The macro below used to work in excel, however, for some reason it now
gives me an error. The error reads:
Compile error: Named argument not found.
The Macro is as follows:
Sub First_Macro_Rate_Sheet_Comparison()
'
' First_Macro_Rate_Sheet_Comparison Macro
'
'
'
Cells.Replace What:="Cell", Replacement:=" - Cellular", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Cells.Replace What:=" - Cellularular", Replacement:=" - Cellular",
LookAt:= _
xlPart, SearchOrder:=xlByRows, MatchCase:=False,
SearchFormat:=False, _
ReplaceFormat:=False
Cells.Replace What:="Mobile", Replacement:=" - Cellular",
LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
Can anyone please help me in figuring out how to solve this error? The
program shows an error at SearchFormat, any ideas?
Thanks,
A.S.
The macro below used to work in excel, however, for some reason it now
gives me an error. The error reads:
Compile error: Named argument not found.
The Macro is as follows:
Sub First_Macro_Rate_Sheet_Comparison()
'
' First_Macro_Rate_Sheet_Comparison Macro
'
'
'
Cells.Replace What:="Cell", Replacement:=" - Cellular", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Cells.Replace What:=" - Cellularular", Replacement:=" - Cellular",
LookAt:= _
xlPart, SearchOrder:=xlByRows, MatchCase:=False,
SearchFormat:=False, _
ReplaceFormat:=False
Cells.Replace What:="Mobile", Replacement:=" - Cellular",
LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
Can anyone please help me in figuring out how to solve this error? The
program shows an error at SearchFormat, any ideas?
Thanks,
A.S.