VBA°ÝÃD ½Ð°Ý¦p¦ó§Q¥ÎVBAÅý¸ê®Æ¨C¦¸°õ¦æ«á¦Û°Ê¶K¤W¨ì³Ì«á¤@®æ
- ©«¤l
- 20
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 31
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- na
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-10-25
- ³Ì«áµn¿ý
- 2014-6-3
|
VBA°ÝÃD ½Ð°Ý¦p¦ó§Q¥ÎVBAÅý¸ê®Æ¨C¦¸°õ¦æ«á¦Û°Ê¶K¤W¨ì³Ì«á¤@®æ
¦U¦ì¤j¤j¦n
½Ð°ÝY·Qn§âªþ¥óªºSHEET3¸Ì±ªºB31:H31
»PB33:H33
·í°õ¦æ¥¨¶°®É·|¦Û°Ê¶K¨ìSHEET1ªºB2:G2
»PSHEET2ªºB:G2
¨Ã¥B¨C¦¸°õ¦æ³£Ã¸¶K¨ì¤U¤@®æ©O??
Y¯à¸Ñµª¤£³Ó·P¿E |
-
-
½d¥».rar
(22.84 KB)
|
mony
|
|
|
|
|
- ©«¤l
- 396
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 425
- ÂI¦W
- 1
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2013-7-2
- ³Ì«áµn¿ý
- 2024-8-23
|
|
|
|
|
|
|
- ©«¤l
- 20
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 31
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- na
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-10-25
- ³Ì«áµn¿ý
- 2014-6-3
|
ÁÂÁÂowen06 ¤j¤j §Ú¤F¸Ñ¤F ÁÂÁ |
|
mony
|
|
|
|
|
- ©«¤l
- 20
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 31
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- na
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-10-25
- ³Ì«áµn¿ý
- 2014-6-3
|
¦^´_ 2# owen06
¤£¦n·N«ä ½Ð°ÝI=2¸òX=2ªº¥Î·N¬O
ªì¾ÇªÌ½Ð¤j¤j«ü¾É ÁÂÁ |
|
mony
|
|
|
|
|
- ©«¤l
- 20
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 31
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- na
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-10-25
- ³Ì«áµn¿ý
- 2014-6-3
|
¦^´_ 4# jimmy121212
·Q¦A½Ð°Ý¤j¤j ¦pªþ¥ó »P¥ý«e¤@¼ËÁÙn¦A¥[¤WA36:M36¶K¨ìSHEET4n«ç»ò¼g©O ¸Õ¤F¦n´X¦¸³£¥¢±Ñ Àµ½Ð¤j¤jÀ°¦£ ÁÂÁ |
|
mony
|
|
|
|
|
- ©«¤l
- 396
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 425
- ÂI¦W
- 1
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2013-7-2
- ³Ì«áµn¿ý
- 2024-8-23
|
¦^´_ 5# jimmy121212
¤£¦n·N«ä¡A¬Q¤Ñ¨º¼Ë¼gªº¤Ó²Â¤F¡A´«¦¨³o¼Ë·|¤ñ¸û¤è«K¡C
¥t¥~§A°Ýµ{¦¡¸ÌªºI¸òX¬O¤°»ò·N«ä¡A¨ä¹ê¨S¤°»ò¯S§O·N«ä¡AÓ¤H²ßºD¦Ó¤w¡A
n³]¤°»ò³£ÀHÓ¤H³ß¦n¡A¤£n½Ä¬ð¨ì´N¦n¡C
²³æªº»¡¡AFOR ¡K... NEXT¡A¬O¤@°j°éªº¤è¦¡¡A
FOR X = 1 TO 10
CELLS(X ,3)=10
NEXT
§A¥ÎF8¤U¥h³v¨B°õ¦æ¡A´N·|µo²{(1,3), (2,3)¤@ª½¨ì(10,3)ªºÀx¦s®æ³£³vÓÅܦ¨10¡A
³o´N¬O°j°é¡A¦ý¬O¦]¬°§A¦³©w¨ì10¡A©Ò¥H¥L¤£·|¦b(11,3)°õ¦æ«ü¥O¡C
¦Ó§Ú³]ªº For X = 2 To Application.CountA(Sheet2.[A:A]) + 1
¥L´N¥i¥H¥Î¤½¦¡¥hpºâ¥X½d³ò¡AÅýXªº³Ì¤jȦ¨¬°¤@ÓÅܼơA
§A¥i¥H¦b§Y®É¹Bºâµøµ¡¿é¤J¡y?Application.CountA(Sheet1.[A:A]) + 1¡z
¥h¬Ý¬Ý¨C¦¸¦³·s¼W¸ê®Æ®É¡A¥Lºâ¥X¨Óªºµª®×¬O¤£¬O¦³©Ò¤£¦P¡C
¤£¹L¦¤W·Q·Q³oÓ¤èªk®¼§bªº¡A§A¥ÎªþÀɪº³oÓ»yªk²³æ©ú¾é¦h¤F¡C
¥H¤W³£¬O¥»ª©¤W±ªº¤j¤j±Ðªº¡A¨Ó³o¯uªº·|Àò¯q¨}¦h®@~ |
|
|
|
|
|
|
- ©«¤l
- 20
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 31
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- na
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-10-25
- ³Ì«áµn¿ý
- 2014-6-3
|
ì¨Ó¬O³o¼Ë°Ú ¦A¦¸·PÁÂowen06 ¤j¤j ³o¸Ì°ª¤â¦h¥B¼ö¤ß Ãø©Ç¨ü¯q¨}¦h |
|
mony
|
|
|
|
|
- ©«¤l
- 20
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 31
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- na
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-10-25
- ³Ì«áµn¿ý
- 2014-6-3
|
¦^´_ 6# owen06
·Q¦A½Ð±Ð ¦pªGn±N¸ê®Æ¶K¨ì¥t¤@ÓWORKBOOKn«ç¼Ë¼g©O??¤£¦n·N«ä §Ú¨S¦³°ò¦ ¸Õ¤F¦n¤[³£¤£¦æ §Æ±æ±z¥i¥H±Ð±Ð§Ú
·P®¦ |
|
mony
|
|
|
|
|
- ©«¤l
- 20
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 31
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- na
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-10-25
- ³Ì«áµn¿ý
- 2014-6-3
|
¥»©«³Ì«á¥Ñ jimmy121212 ©ó 2013-11-11 17:03 ½s¿è
[attach]16665[/attach]¦^´_ 9# GBKEE
GBKEE¤j¤j ¤p§Ì¸Õ¹L¦h¦¸ ÁÙ¬O¿ù»~ ¤p§Ì«pÃCªº·Q½Ð°Ý:dizzy: ¤£ª¾±z¥i§_À°§Ú¼g¤W §Ú¦AºCºC¹ï·Ó¾Ç²ß
§Ún±N"¥~¸ê¤Î¨ä¦ÛÀç"Àɮפ¤*¨C¤é·§ºâªí*ùتº(B37:E37)»P(B38:E38)¦Û°Ê½Æ»s¨ìÀÉ®×*¾ú¥v¥¼¥Üªº(E:H)»P(R:U)
·PÁÂ |
|
mony
|
|
|
|
|