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
|