Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find in 2000 and xp
On Tue, 29 Jul 2003 17:21:12 +1000, chris wrote:
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
find in 2000 and xp
Thanks Sander, that fixed the problem Chris *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find duplicates in Excel 2000 | Excel Discussion (Misc queries) | |||
how to use find binoculars in excel 2000 .xls ? | Excel Worksheet Functions | |||
where can i find Formulas for excel 2000? | Excel Worksheet Functions | |||
How do I find out if I have Office 2000 | Excel Discussion (Misc queries) | |||
cannot find list in excel 2000 | Excel Discussion (Misc queries) |