find in 2000 and xp

  • Thread starter Thread starter chris
  • Start date Start date
C

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
 
Columns("A:A").Select
Selection.Find(What:="Date", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
Click to expand...

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
 
Back
Top