SearchFormat and ReplaceFormat

[Guest]

I am having some issues going between versions. My box has Excel 2002 and I
am writing a macro for people using Excel 2000.

My find looks like this --- "Cells.Find(What:="Sample Type",
After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate" -- it works fine
in 2002

but on Excel 2000 the "SearchFormat:=False" gives an error.

If I change the find to -- " Cells.Find(What:="Sample Type",
After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _
MatchCase:=False).Activate" -- it works in 2000 but not in 2002

Any help on a find and or find replace that will work in Excel 2000+???

Thanks
Mike

 

[Don Guillett]

I just tested the last in xl2002 and it worked fine. I don't have 2000 but
also tested in xl97sr2 and it worked fine.