![]() |
Macro Error
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. |
All times are GMT +1. The time now is 05:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com