Á¦°¡ ¿¢¼¿ Ãß÷ ¸ÅÅ©·Î¸¦ ÀÎÅͳݿ¡¼ ¹Þ¾Ò´Âµ¥¿ä.
ÇöÀç´Â ´ë»óÀÚ¸í´Ü¸¸ ÃßÃâÀ̵˴ϴÙ.
<VBA ÄÚµåÀÔ´Ï´Ù.>
Sub Lottery()
Dim RngLot As Range, R As Range
Dim CountAll As Integer, CountLot As Integer
Range("F2:F65536").ClearContents '±âÁ¸¿¡ Ãß÷ÀÚ ¸í´ÜÀ» Áö¿ò
CountLot = Val(InputBox("¸î¸íÀ» Ãß÷ÇÒ±î¿ä?")) 'Ãß÷ÀÚ ¼ö¸¦ ÀԷ¹ÞÀ½
Set RngLot = Range(Range("F2"), Range("F2").Offset(CountLot - 1, 0)) '´ç÷ÀÚµéÀ» ÀÔ·ÂÇÒ ¹üÀ§ ¼³Á¤
CountAll = Range(Range("A2"), Range("A2").End(xlDown)).Count 'ÃÑ Ãß÷´ë»óÀÚÀÇ ¼ö¸¦ °è»ê
Randomize '³¼ö¹ß»ý ÃʱâÈ
For Each R In RngLot '´ç÷ÀÚ ÀԷ¹üÀ§ÀÇ °¢°¢ÀÇ ¼¿¿¡ ´ëÇÏ¿©
Do
R = Cells(Int((CountAll * Rnd) + 2), 1).Value '´ë»óÀÚÁß ÇѸíÀ» ·£´ýÇÏ°Ô »Ì¾Æ ±â·ÏÇϵÇ
Loop While Application.WorksheetFunction.CountIf(RngLot, R.Value) > 1 'ÀÌ¹Ì »ÌÈù »ç¶÷ÀÌ Áߺ¹µÇÁö ¾Ê°Ô loop¸¦ µ¹¸²
Next
End Sub
»çÁøÆÄÀÏó·³ Ãß÷ÇÒ¶§ ´ë»óÀÚ¸í´Ü¿¡¼ ÀÌÀ¯±îÁö ÃßÃâÇÒ ¼ö ÀÖ°ÔÇÏ·Á¸é Äڵ带 ¾î¶»°Ô Â¥¾ß ÇÒ±î¿ä?¤Ð¤Ð
°í¼öºÐµé ºÎŹ Á» µå¸®°Ú½À´Ï´Ù..!!
|
Ãß÷ ¸ÅÅ©·Î´Â ¿©±â¼ ¹Þ¾Ò½À´Ï´Ù.