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

¸ß°Ý§Q¥ÎVBAªºFor°j°é±a¤J¸ê®Æ¨ìÀx¦s®æ¤ºªº¼gªk

¸ß°Ý§Q¥ÎVBAªºFor°j°é±a¤J¸ê®Æ¨ìÀx¦s®æ¤ºªº¼gªk

·Q¸ß°Ý¹³³o¼ËÅýD¦Cªº¸ê®Æ¥ÑVBA±a¤Jªº¸Ü
­Y­n¨Ï¥Îfor°j°é ¦Û°Ê¼g¤J­n«ç»ò¼g©O....
¦]¸ê®Æ¨Ã¨S¦³³o»ò¤Ö...

[D1].Formula = "1"
[D2].Formula = "2"
[D3].Formula = "3"
[D4].Formula = "4"
[D5].Formula = "5"

¥»©«³Ì«á¥Ñ starry1314 ©ó 2015-9-3 17:54 ½s¿è

¦^´_ 1# toromru

Sub ¨Ì§Ç¶ñ¤J()

For i = 1 To 830
          Range("D" & i + 1) = i + 1
         Next

End Sub

TOP

¥»©«³Ì«á¥Ñ toromru ©ó 2015-9-3 18:39 ½s¿è

¦^´_ 2# starry1314


   ±z¦n

     ¥D­n¬O ±q³o»yªk ¦p¦ó§ï?   [D1].Formula = "1"

     ¬O§ï¦¨?  

     For i = 1 To 830

          ["D" & i + 1].Formula = i
         
         Next

    °õ¦æ«á ĵ¥Ü ¦¹³B»Ý­nª«¥ó!!!

TOP

¦^´_ 2# starry1314


    Sorry

    §Ú¤wª¾¹D «ç¼g¤F  «D±`·PÁ§Aªº»yªk~

    ¥i¥H¨Ï¥Î­ò!!

TOP

        ÀR«ä¦Û¦b : Ä@­n¤j¡B§Ó­n°í¡B®ð­n¬X¡B¤ß­n²Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD