Thread
:
SearchFormat and ReplaceFormat
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
SearchFormat and ReplaceFormat
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.
--
Don Guillett
SalesAid Software
"Mike" wrote in message
...
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
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]