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

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

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

--
Don Guillett
SalesAid Software

"Chris" wrote in message
...
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