Range("a:a").Find(5)ºë·Çªº¥Îªk
- ©«¤l
- 25
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-2-16
- ³Ì«áµn¿ý
- 2024-3-7
|
Range("a:a").Find(5)ºë·Çªº¥Îªk
½Ð±Ð¥ý¶i
A1Àx¦s®æªºÈ¬OªÅ¥Õ
A2Àx¦s®æªºÈ¬OªÅ¥Õ
A3Àx¦s®æªºÈ¬O 56
A4Àx¦s®æªºÈ¬O 5
¨Ï¥Î«ü¥O
Set rng = Range("a:a").Find(5)
MsgBox rng.Row
µ²ªG¬O3 ===>§Únªºµ²ªG¬O4
½Ð±Ð¦p¦ó¯àºë·Çªº§ä¨ì5¦Ó¤£56? ·PÁÂ! |
|
|
|
|
|
|
- ©«¤l
- 1572
- ¥DÃD
- 16
- ºëµØ
- 2
- ¿n¤À
- 1521
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2016-1-13
|
MsgBox [a:a].Find(5, , , 1).Row |
|
|
|
|
|
|
- ©«¤l
- 25
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-2-16
- ³Ì«áµn¿ý
- 2024-3-7
|
·P®¦ ,
¦A½Ð±Ð¦pªG·Qn, ¦b[a:a]·j´M5, [b:b]·j´M6, [c:c]·j´M7, ¦Ó¥Bµ²ªG¥²¶·¦b¤@¦C, ½Ð±Ð¦p¦ó¥ÎFindªº«ü¥O¼gªk,³t«×·|¤ñ¸û§Ö, ÁÙ¬Ooobird¥ý¶i¦³Find¨ä¥L¬ÛÃö¥Îªk¯à¤@¨Ö½ç±Ð, Åý§Ú¯à¦h¦h¥R¹êvba¥\¤O, ·PÁÂ! |
|
|
|
|
|
|
- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
- Sub FIND()
- For i = 1 To 3
- c = 1
- Columns(i + 4) = ""
- Set rng = Columns(i).FIND(i + 4, , , xlWhole)
- If Not rng Is Nothing Then
- findrow = rng.Row
- Do
- Cells(c, i + 4) = rng.Row
- c = c + 1
- Set rng = Columns(i).FindNext(rng)
- Loop While Not rng Is Nothing And rng.Row <> findrow
- End If
- Next i
- End Sub
½Æ»s¥N½X ¦^´_ 3# openpc |
|
|
|
|
|
|
- ©«¤l
- 12
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003/2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-24
- ³Ì«áµn¿ý
- 2019-2-26
|
I think.....- Cells.Find(what:="56", After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, MatchByte:=False, SearchFormat:=False).Activate
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 25
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-2-16
- ³Ì«áµn¿ý
- 2024-3-7
|
·PÁÂ¥ý¶iÌ«ü±Ð, ¤´¦b¿n·¥ºt½m®ø¤Æ¤¤. |
|
|
|
|
|
|
- ©«¤l
- 1572
- ¥DÃD
- 16
- ºëµØ
- 2
- ¿n¤À
- 1521
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2016-1-13
|
find¤èªk¦bvba¤¤¨Ï¥Î¬Û·í¼sªx
«Øij¦h½m²ß¡G
1.find¤u§@ªí¤W¬YÈ¥X²{ªº¦ì¸m
2.find¤u§@ªí¤W¤½¦¡±a¥X¬YȪº¦ì¸m
3.find¤u§@ªí¤W³]©w¬Y®æ¦¡ªº¦ì¸m¡A¦p¶ñº¡¦â±m©Î²ÊÅé¤å¦r
4.find¤u§@ªí¤W³]©w¦X¨ÖÀx¦s®æªº¦ì¸m |
|
|
|
|
|
|