- ©«¤l
- 13
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 15
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- office2016
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2018-8-12
- ³Ì«áµn¿ý
- 2018-10-11
|
½Ð±Ð¦U¦ì¥ý¶i,¤p§Ì¥¿¦b°µ¼ÒÀÀÅçÃÒ,¨Ï¥Î¶Ã¼Æ²£¥Í¾¹²£¥Í¼Æ¾Ú¶i¦æ¼ÒÀÀÅçÃÒ,
§Ú¦bVBA¤W¼g¤F¤@¬qµ{¦¡²£¥Í¤F¥¨¶°«ö¶s¥i¥H¦bA1:A7²£¥Í¤@¶gªº¶Ã¼Æ,¥i¬O
§Ú·Qn¦b¨C«ö¤@¦¸¥¨¶°«ö¶s´N¦A¦Û°Ê©¹¤U²£¥Í¤@¶g(A8:A14)ªº¶Ã¼Æ¸Ó¦p¦ó
½s¼g©O?
Sub Project1_Click()
Dim rTar As Range
Randomize
For Each rTar In Range("A1:A7")
rTar = Int((21 - 1) * Rnd + 1) * 0.01
Next
End Sub |
|