AW: per Zufall auswählen
16.05.2006 14:19:20
Franz
Hallo Jusuf,
hier der Makro-Code:
Sub Zufallsauswahl()
'Aus Tabelle1 e i n e Zeile von Zeile 1 bis Zeile 1000
'per Zufall auswählen und in
'Tabelle2 ab B5:J5 eintragen, ohne wiederholung
Dim wks1 As Worksheet, wks2 As Worksheet, Zeile1 As Long, Nummer As Long
Dim Untergrenze As Long, Obergrenze As Long, I As Long, J As Long
Set wks1 = ActiveWorkbook.Sheets("Tabelle1")
Set wks2 = ActiveWorkbook.Sheets("Tabelle2")
Zeile1 = 5
Untergrenze = 1
Obergrenze = 1000
For I = 1 To 21
wiederholung:
Nummer = Int((Obergrenze - Untergrenze + 1) * Rnd + Untergrenze)
For J = 1 To I - 1
If Nummer = wks2.Cells(Zeile1 + J - 1, "B") Then GoTo wiederholung
Next J
wks2.Range(wks2.Cells(Zeile1 + I - 1, "B"), wks2.Cells(Zeile1 + I - 1, "J")).Value = _
wks1.Range(wks1.Cells(Nummer, "A"), wks1.Cells(Nummer, "I")).Value
Next I
End Sub
Gruß
Franz