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

[µo°Ý] VBA ¹Bºâ«á¦Û°Ê´«¦æ

  1. Sub Project1_Click()
  2. Dim rTar As Range, r&
  3. r = Cells(Rows.Count, 1).End(3).Row
  4. If Not r = 1 Then r = r + 1
  5. Randomize
  6. For Each rTar In Cells(r, 1).Resize(7)
  7. rTar = Int((21 - 1) * Rnd + 1) * 0.01
  8. Next
  9. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ­×¦æ­nô½t­×¤ß¡AÂǨƽm¤ß¡AÀH³B¾i¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD