Thread: Compiler Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
 
Posts: 788
Default Compiler Error

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