Hi
this property is not support in Excel 97

--
Regards
Frank Kabel
Frankfurt, Germany

"Chris" schrieb im Newsbeitrag
...
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