Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SearchFormat and ReplaceFormat
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replaceformat problem | Excel Discussion (Misc queries) |