Thread: Macro Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
A.S. A.S. is offline
external usenet poster
 
Posts: 79
Default Macro Error

Hello,
I needed some help with a macro that used to work, but for some reason
does not work anymore. The error that is displayed is: Compile error: Named
argument not found.

The macro is as follows:
Sub First_Macro_Rate_Sheet_Comparison()
'
' First_Macro_Rate_Sheet_Comparison Macro
' Macro recorded 3/4/2005 by Edits
'

'
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

The program stops at SearchFormat, any ideas. Any help would be appreciated.

Thanks,
A.S.