Excell.Cells.Find为什么老出 类 Range的Find方法无效,该怎么写呢????
Sheet.Cells.Find(what:='#Q.F1',After:=Sheet.cells.Activate,LookIn:=xlFormulas,LookAt:=xlPart,SearchOrder:=xlByRows,SearchDirection:=xlNext,MatchCase:=0,MatchByte:=0).Row;
宏是这样写的,
Cells.Find(What:="#Q.F1, After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False).Row
请教该怎么写呢?????