View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Getting error in code

hi,
Try changing to this
MyKey = Cells.Find(What:="1Insu"), After:=ActiveCell,
I am not sure what Inus is.

note: it is not wise to write code in a applicatin version
higher that the version the code will be run in.
code should be written on the version that it will run in.
many time there are no problems but sometime there are.
-----Original Message-----
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
.