Getting error in code
Thanks Norman;
I did remove-it and did a re-run;
but it bombed and highlighted the entire statement;
Any suggestions as to a remedy
-----Original Message-----
Hi Jim,
SearchFormat:=False
The SearchFornat argument is not available in xl2k.
---
Regards,
Norman
"Jim May" wrote in
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
.
|