- ©«¤l
- 3
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 10
- ÂI¦W
- 0
- §@·~¨t²Î
- window
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2016-6-22
- ³Ì«áµn¿ý
- 2020-6-26
|
[µo°Ý] ½Ð°Ý find µLªk·j´M¸óÄæ¸m¤¤¤§Äæ¦ì
¦pÃD ¨Ï¥Îfind·j´M®É
sc = Cells.Find(What:="¦U½u§÷Â_½u²v", after:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=False, MatchByte:=False, SearchFormat:=False).Row
¥X²{"¨S¦³³]©wª«¥óÅܼƩÎwith°Ï¶ôÅܼÆ" ¤§°T®§
¥Ñ©ó "¦U½u§÷Â_½u²v" ©Ò¦bÄæ¦ì¬° A22¨ìB22 (¸óÄæ¸m¤¤)
¸g¹L´ú¸Õ«áµo²{ ¨ú®ø ¸óÄæ¸m¤¤ ¦A°õ¦æµ{¦¡´N¥i¥H·j¸ß¨ì
½Ð°Ý¦³¤°»ò¤è¦¡¥i¥H¦b"¦U½u§÷Â_½u²v"¸óÄæ¸m¤¤ªº±¡ªp¤U¡A·j¸ß¨ì¸Ó¦ì¸m¶Ü?
©Î¬Oµ{¦¡½X¥i¥H¨ú®ø©Ò¦³Äæ¦ìªº¸óÄæ¸m¤¤ |
|