Compiler Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have written a macro in Excel 2002 SP1 which works fine. I ran it on Excel
version 97 SR1 and get the following error

Compile error
Named argument not found

This is the line
Cells.Replace What:="$", Replacement:="£", LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False
and it highlights the Searchformat:=false

Any suggestions how to get around this

Cheers
Chris
 
The last 2 are probably not supported. In fact, it should work if you delete
all after xlPart.
BTW. Are you really looking for xlpart or maybe you want xlwhole??
 
Back
Top