½Ð¦U¦ì¤j¤jÀ°¦£¬Ý¤@¤U!!¦]¬°§Ú¤£ª¾¹Dn«ç»ò¸ÑÄÀ¼ÐÃD
- ©«¤l
- 5
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 13
- ÂI¦W
- 0
- §@·~¨t²Î
- W7-64
- ³nÅ骩¥»
- Office2003-2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-6-18
- ³Ì«áµn¿ý
- 2013-7-3
|
½Ð¦U¦ì¤j¤jÀ°¦£¬Ý¤@¤U!!¦]¬°§Ú¤£ª¾¹Dn«ç»ò¸ÑÄÀ¼ÐÃD
|
|
|
|
|
|
- ©«¤l
- 5
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 13
- ÂI¦W
- 0
- §@·~¨t²Î
- W7-64
- ³nÅ骩¥»
- Office2003-2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-6-18
- ³Ì«áµn¿ý
- 2013-7-3
|
½Ð°Ý³£¨S¦³¤H¦^µª....¬O¦]¬°§Ú·Qnªº¤èªk¨S¿ìªk¹ê²{¹À!?ÁÙ¬O»¡....¤j®a¤£Ä@·N¸ò§Ú»¡ |
|
|
|
|
|
|
- ©«¤l
- 5
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 13
- ÂI¦W
- 0
- §@·~¨t²Î
- W7-64
- ³nÅ骩¥»
- Office2003-2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-6-18
- ³Ì«áµn¿ý
- 2013-7-3
|
¥»©«³Ì«á¥Ñ kenson ©ó 2012-7-9 17:31 ½s¿è
¶Wª©¤j¤j!!
«D±`·PÁ±zÀ°§U!
¦ý¬O...¸ò§Ú¹w´Áªº¤£¤@¼Ë...
§ÚªºA¬¡¶Ã¯¦b¿é¤J¶i(A1)½s¸¹«á¦^¶Ç(N1)¸ê®Æ¡AB¬¡¶Ã¯»Ýn¯d¤U½s¸¹¸ò¨ä¥L¦P¦C¸ê®Æ¥u»Ýn§R°£¤@Ó¦sÀx®æ(G)ªº¸ê®Æ¡C
±zªº¤è¦¡¦n¹³¬O§â¾ãÓ¯P³£§R°£¤F....©Ò¥H³o¤è±¯à¦A§ï¶Ü@@?
¤£¦n·N«ä³Â·Ð±z¤F....
|
|
|
|
|
|
|
- ©«¤l
- 5
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 13
- ÂI¦W
- 0
- §@·~¨t²Î
- W7-64
- ³nÅ骩¥»
- Office2003-2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-6-18
- ³Ì«áµn¿ý
- 2013-7-3
|
¶Wª©¤j¤j«D±`·PÁ±zªº¸Ô²Ó¸Ñµª!!§Ú¸Ñ¨M¤F!!
§Ú¦A½Ð±Ð¤@Ó°ÝÃD...´N¬O¦pªGn§âA¬¡¶Ã¯A1¿é¤J½s¸¹ªº®æ¤l§ï¦¨C1
VB¨ºÃän«ç»ò§ï?
Set a = Workbooks("B¬¡¶Ã¯").Sheets(1).Columns("A").Find(Target, lookat:=xlWhole)
§Ú§â¤W±ªºA§ï¦¨C ¥L¤£·|§R°£¤F.....
ÁÙ¬O
If Not a Is Nothing And Target <> "" Then Target.Offset(, 13) = a.Offset(, 6).Value: a.Offset(, 6) = ""
³oÃän§ï?¬O§â13§ï¦¨11¶Ü?§Ú¹Á¸Õ¹L¤]¨S¿ìªk!!
¥t¥~¦pªGB¬¡¶Ã¯ªº¤u§@ªí§ï¦W¤l ¡A¬On§ïþ¸Ì!? |
|
|
|
|
|
|
- ©«¤l
- 5
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 13
- ÂI¦W
- 0
- §@·~¨t²Î
- W7-64
- ³nÅ骩¥»
- Office2003-2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-6-18
- ³Ì«áµn¿ý
- 2013-7-3
|
«D±`·PÁ¶Wª©¤j¤jªº¸Ô²Ó¸Ñ»¡!!
§Ú¤w¸g¥i¥H¨Ï¥Î¤F~«D±`ºë·Ç~!
¦A¦¸·PÁ±z^^ |
|
|
|
|
|
|