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

[µo°Ý] ½Ð±Ð:¦b«ü©wªºÀx¦s¤º¿é¤J¥ô·N¼Æ,§Y¥i°õ¦æ¸Ó¥ô·N¼Æªº¦¸¼Æ

[µo°Ý] ½Ð±Ð:¦b«ü©wªºÀx¦s¤º¿é¤J¥ô·N¼Æ,§Y¥i°õ¦æ¸Ó¥ô·N¼Æªº¦¸¼Æ

½Ð±Ð¦U¦ì¦Ñ®v:
¥H¤U¬OÅý "XYZ" ³oµ{¦¡°õ¦æ100¦¸ªºµ{§Ç
­Y¤£·Q¶i¤J¥¨¶°¤º­×§ï For i = 1 To 100 ªº¼Æ­È
¦Ó¦b«ü©wªºÀx¦s¤º¿é¤J¥ô·N¼Æ,¨Ò¦p¦b A5 Àx¦s®æ¤º¿é¤J500 ªº¼Æ¦r«á,§Y¥i°õ¦æ "XYZ" 500¦¸ªºµ{§Ç.
½Ð°Ý¸Ó¦p¦ó³B²z?
ÁÂÁÂ
------------
Sub ¦¸¼Æ()

For i = 1 To 100
XYZ
Next i

End Sub
·PÁ¦U¦ì¦Ñ®vªá¤ß«ä±Ð¾É

¦^´_ 1# jonn0510
¨Ò¦p¦bA1Àx¦s®æ¿é¤J¦¸¼Æªº¼Æ¦r

For i = 1 To [A1]
XYZ
Next i
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

Hsieh ¦Ñ®v:
·PÁ±zªº«ü¾É.ÁÂÁ±z
·PÁ¦U¦ì¦Ñ®vªá¤ß«ä±Ð¾É

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD