Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting error in code
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting error in code
Forget the above; I tried it again after removing it
and it worked!! I must have screwed up the 1st try; can't imagine... LOL Thanks to all, -----Original Message----- 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 . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code error | Excel Discussion (Misc queries) | |||
How can I still go to the error-code after a On Error Goto? | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming | |||
Add-in Error , code help | Excel Programming | |||
Error code=2 | Excel Programming |