- ©«¤l
- 552
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 578
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-2-8
- ³Ì«áµn¿ý
- 2024-7-9
|
¦^´_ 11# idnoidno
¬O³o¤@¦C¶Ü¡H
RngRow = ¤u§@ªí1.Columns(Rng.Column).Find("*", , , , , xlPrevious).Row '´M§ä§ïÄ檺³Ì«á¤@ÓÀx¦s®æ
¨ä¤¤¡A¤u§@ªí1.Columns(Rng.Column)¬O´M§äªº½d³ò©Ò¹ïÀ³ªºÄæ¡A§Ú¥H°ÊºA´`Àô¨Ó§ïÅÜ¥¦´M§äªº½d³ò¡A¥H´`Àôªº²Ä¤@¦¸°j°é¨Ó»¡¡A¥¦·|·j´M"¥Ò"¨º¤@Äæ³Ì«á¦³"È"ªºÀx¦s®æ¨Ó¶Ç¦^©Ò¹ïÀ³ªº¦C¸¹Row¡A§Ú¥H¸U¥Î¦r¤¸ * ¨Ó¥Nªí¥ô¦ó¦r¦ê¡AxlPrevious¬O¥Ñ¤U©¹¤W§ä,
¥H¤U¬OÂ^¨úExcel»¡©úRange.Findªº»¡©úµ¹°Ñ¦Ò¡I
Excel ¶}µo¤Hû°Ñ¦Ò¸ê®Æ
Range.Find ¤èªk
·|´M§ä½d³ò¤¤ªº¯S©w¸ê°T¡C
»yªk
¹Bºâ¦¡.Find(What, After, LookIn, LookAt, SearchOrder, SearchDirection, MatchCase, MatchByte, SearchFormat)
¹Bºâ¦¡ ¥Nªí Range ª«¥óªºÅܼơC
°Ñ¼Æ
¦WºÙ ¥²n/¿ï¥Î ¸ê®ÆÃþ«¬ ´yz
What ¥²n Variant n·j´Mªº¸ê®Æ¡C¥i¥H¬°¦r¦ê©Î¥ô¦ó Microsoft Excel ¸ê®ÆÃþ«¬¡C
After ¿ï¥Î Variant «ü©wÀx¦s®æ¡A·j´M±N·|±q³oÓÀx¦s®æ¤§«á¶}©l¡C³oÓÀx¦s®æ¹ïÀ³©ó±q¨Ï¥ÎªÌ¤¶±°õ¦æ·j´M®Éªº§@¥ÎÀx¦s®æ¦ì¸m¡Cª`·N¡AAfter ¥²¶·¬O½d³ò¤¤ªº³æ¤@Àx¦s®æ¡C½Ð°O¦í·j´M¬O±q³oÓÀx¦s®æ¤§«á¶}©l¡A¦]¦¹¥²¶·µ¥¨ì¸Ó¤èªk´`Àô¦^¨ì«ü©wªºÀx¦s®æ®É¡A¤~·|·j´M¨ä¤º®e¡C¦pªG¨S¦³«ü©w³oӤ޼ơA«h·j´M·|±q½d³ò¥ª¤W¨¤ªºÀx¦s®æ¤§«á¶}©l¡C
LookIn ¿ï¥Î Variant ¸ê°TªºÃþ«¬¡C
LookAt ¿ï¥Î Variant ¥i¥H¬°¤U¦C¨ä¤¤¤@Ó XlLookAt ±`¼Æ¡GxlWhole ©Î xlPart¡C
SearchOrder ¿ï¥Î Variant ¥i¥H¬°¤U¦C¨ä¤¤¤@Ó XlSearchOrder ±`¼Æ¡GxlByRows ©Î xlByColumns¡C
SearchDirection ¿ï¥Î XlSearchDirection ·j´M¤è¦V¡C
MatchCase ¿ï¥Î Variant ¦pªG¬° True¡A«h·j´M®É·|±N¤j¤p¼gµø¬°¬Û²§¡C¹w³]Ȭ° False¡C
MatchByte ¿ï¥Î Variant ¥u¦³·í±z¤w¿ï¨ú©Î¦w¸ËÂù¦ì¤¸²Õ»y¨¥¤ä´©®É¡A¤~¯à¨Ï¥Î¡C¦pªG¬° True¡A«hÂù¦ì¤¸²Õ¦r¤¸¥u¯à²Å¦XÂù¦ì¤¸²Õ¦r¤¸¡C¦pªG¬° False¡A«hÂù¦ì¤¸²Õ¦r¤¸¥i²Å¦X¹ïÀ³ªº³æ¦ì¤¸²Õ¦r¤¸¡C
SearchFormat ¿ï¥Î Variant ·j´M®æ¦¡¡C |
|