find in 2000 and xp

[chris]

I have the following code in a program which runs ok in excel xp.

Columns("A:A").Select
Selection.Find(What:="Date", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate

When run on a friends pc which has excel 2000 it fails at the selection.find
line.

Could someone tell me if there is a difference between xp and 2000 and if
there is, what is the syntax for this command in 2000?

Thanks
Chris

 

[Sander Lablans]

Columns("A:A").Select
Selection.Find(What:="Date", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate

The only thing that stops this piece of code from working is the
'SearchFormat:=False' part. If you delete this, then the code works
perfectly in XL2000.

SL

 

[chris gee]

Thanks Sander, that fixed the problem
Chris

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!