View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chris[_3_] chris[_3_] is offline
external usenet poster
 
Posts: 5
Default find in 2000 and xp

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