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

for -step- nextÂùÅܼƦ^°é«ç»ò¼g

·Q§â¤u§@ªí1¸Ìªº¤º®eÅã¥Ü©ó¤u§@ªí2
¦p¦ó§Q¥Îfor-step-next¼g¥X¨Ó©O?
¦ý¥u¯à¦³1­ÓÅܼƦ^°é
oak0723-1 µoªí©ó 2010-8-30 14:25
  1. Sub test()
  2.     For i = 2 To 11 Step 1  '«á­±ªº Step 1 ¥i¬Ù²¤,§ï¬° For i = 2 To 11 §Y¥i
  3.         Worksheets("2").Cells(i * 2, 4) = Worksheets("1").Cells(i, 2).Value
  4.     Next i
  5. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD