Compiler Error

[Chris]

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

 

[Frank Kabel]

Hi
this property is not support in Excel 97

 

[Don Guillett]

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??