ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] find lookat°Ñ¼Æ¦³°ÝÃD ?

[µo°Ý] find lookat°Ñ¼Æ¦³°ÝÃD ?

XlWhole ¬O¥þ³¡²Å¦X
xlPart  ¬O³¡¥÷²Å¦X
Book2.rar (8.89 KB) ªþÀɤ¤¬O§¹¥þmatchªºª¬ºA¬°¦ó¥Î XlWhole §ä¤£¨ì??¥ÎxlPart¤~§äªº¨ì?

°Ñ¼Æ LookAt¡A¥i¿ï¡C¥i¥H¬°¥H¤U±`¶q¤§¤@¡G
XlWhole©ÎªÌxlPart¡A¥Î¨Ó«ü©w©Ò¬d§äªº¼Æ¾Ú¬O»P³æ¤¸®æ¤º®e§¹¥þ¤Ç°tÁÙ¬O³¡¤À¤Ç°t¡AÀq»{­È¬°xlPart

¥»©«³Ì«á¥Ñ t8899 ©ó 2014-8-23 09:01 ½s¿è
¦^´_  t8899
Âk¯Ç¤@¤U
LookIn:=xlValues
Àx¦s®æ¥i¥H¬O¤½¦¡,¨ç¼Æ¶Ç¦^¨Óªº¼Æ­È¤å¦r
Àx¦s®æ®æ¦¡¤£¥i¬O ...
GBKEE µoªí©ó 2014-8-23 08:33

¨S¿ù¡A§Ú¥Î¿ý»s¥¨¶° (·j´M) ±o¨ì¥H¤Uªºµ²½×
xlFormulas ==>    §äªº¬O¤½¦¡¸Ì¸Ì­±ªº¤º®e¤£¬O­È(µ¥©ó¸õ¹L¤½¦¡ªº­È¤£§ä ) (¤Î¤@¯ëªº¤å¦r¤Î¼Æ¦r )
xlValues====>   ¤@¯ëªº¤å¦r¤Î¼Æ¦r (§t¤½¦¡ªº­È,¤£¥]¬A¤½¦¡ªº¤º®e)
Àx¦s®æ®æ¦¡¤£¥i¬O [³q¥Î®æ¦¡] ¥H¥~ªº®æ¦¡ ==>³oÂI§Ú­Ë¨Sª`·N¡AÁÂÁ´£¿ô!
°Ñ¼Æ¨S¦³¥ý¸Õ¥Î¡AÁÙ¯uªº¤£ª¾¿ùªº­ì¦]¬O¤°»ò...

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2014-8-23 12:54 ½s¿è

¦^´_ 3# t8899
Âk¯Ç¤@¤U
LookIn:=xlValues

Àx¦s®æ: ¼Æ­È,¤å¦r (¥i¥H¬O¤½¦¡,¨ç¼Æ¶Ç¦^¨Ó)
Àx¦s®æ®æ¦¡¤£¥i¬O [³q¥Î®æ¦¡] ¥H¥~ªº®æ¦¡

LookIn:=xlFormulas
¦³®æ¦¡¤Æ«áªºÀx¦s®æ:値 (¤£¬O¥H¤½¦¡©Î¨ç¼Æ¶Ç¦^¨Óªº¤º®e)

·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¥»©«³Ì«á¥Ñ t8899 ©ó 2014-8-23 06:35 ½s¿è
¦^´_  t8899
¼Æ¦r LookIn:=xlFormulas
¦r¦ê LookIn:=xlValues
GBKEE µoªí©ó 2014-8-23 04:32

·Ó²z §â "9882" À³¸Ó¤]¥i·í¦¨¦r¦ê³B²z§a  ???¦pªGÅývb §â9882 ·í¦¨¦r¦ê ­n¦p¦ó°µ?
¤U­±ªº¨Ò¤l«Ü©úÅã¬O¼Æ¦rªº¥[Á`¥Î xlFormulas ´N¤£¦æ¤F  ??
Book2.rar (10.15 KB)

TOP

¦^´_ 1# t8899
¼Æ¦r LookIn:=xlFormulas
¦r¦ê LookIn:=xlValues
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : ÀR§¤±`®¦¤v¹L¡B¶¢½Í²ö½×¤H«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD