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

vba loop ¤@°Ý

vba loop ¤@°Ý



·Q §ó§ïcell (C,9) ªº¼Æ­È
ª½¦Ü cell (C,30)ªº¼Æ­È µ¥©ó cell (C,31)ªº¼Æ­È
½Ð°ÝÀ³¸Ó¦p¦ó½s¼g?
ÁÂÁÂ

¦^´_ 1# drgv11


    «Øij§âÀÉ®× PO ¥X¨Ó¥i¯à·|¸û®e©ö§ä¨ìµª®×

TOP

¦^´_ 3# drgv11
¨º§A´N¥Î°õ¦æ¦¸¼Æ¨Ó­­¨î°j°é¤£Åý¥¦Åܦ¨µL­­Åo.

¨ä¹ê¤@­Óµ{¦¡¼g¥X¨Ó«á,
­è¶}©l®É³Ì¦n¯à¥Î³æ¨B¼Ò¦¡½T»{¨C¤@¨BÆJªºµ²ªG²Å¦X§Ú­Ìªº¹w´Á,
­Y§_«hÀ³½Õ¾ãµ{¦¡,
ª½¨ì§Ú­Ì½T»{¤£·|µo¥Í«D¥i¹w´Áªº¿ù»~«á¦A«ö F5 §¹¾ã°õ¦æ¤U¥h.

TOP

¦^´_ 2# luhpro

ÁÂÁÂ
¦pªG§Ú¹ê»Ú±¡§Î¬O³o¼Ëªº
http://forum.twbts.com/viewthread.php?tid=17350&extra=

À³¸Ó¦pªG½s¼g

TOP

¥»©«³Ì«á¥Ñ luhpro ©ó 2016-5-6 23:19 ½s¿è
·Q §ó§ïcell (C,9) ªº¼Æ­È
ª½¦Ü cell (C,30)ªº¼Æ­È µ¥©ó cell (C,31)ªº¼Æ­È
½Ð°ÝÀ³¸Ó¦p¦ó½s¼g?
ÁÂÁÂ
drgv11 µoªí©ó 2016-5-5 12:18

Wile [C30] <>[ C31]
  Åܧó {C9] ¤º®eªº«ü¥O (¯S§O¯d·N, ¥²¶·¯à¹F¦¨ [C30] =[ C31], §_«h·|³y¦¨µL½a°j°é -> µ{¦¡·í±¼, ¸U¤@µo¥Í¥i¹Á¸Õ«ö ESC «öÁä¬Ý¬O§_¯à¨ú¦^±±¨îÅv)
Wend

­Y¬°¨¾¤î³y¦¨µL½a°j°é,
¥i¥H§ï¬° :

Wile [C30] < [C31]
...

©Î¬O

i=1
Do Wile [C30] <>[ C31]
  Åܧó {C9] ¤º®eªº«ü¥O
  i=i+1
  if i > 100 Then Exit Do ' ­Y°õ¦æ¶W¹L 100 ¦¸«h°h¥X°j°é
Loop

¬Ò¥i.

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD