View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim May[_4_] Jim May[_4_] is offline
external usenet poster
 
Posts: 6
Default Getting error in code

Code I prepared at home on Excel XP, when brought to work
and run on Excel 2000 is halting on last line,
highlighting "SearchFormat:=": <<What's the prob?
Probably has to do with the Tools, References.. which
I'm not familiar with like I'm gonna be...LOL
TIA,

Dim MyKey As String
....
....
MyKey = Cells.Find(What:="1)Insu", After:=ActiveCell,
LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows,
SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate