1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
Function tiragevide(R As Range, R2 As Range, R3 As Range, R4 As Range, R5 As Range, condition As String) As String
Final = R.Rows.Count
colonne = R.Column
colonne2 = R2.Column
colonne3 = R3.Column
colonne4 = R4.Column
colonne5 = R5.Column
i = Round(Application.WorksheetFunction.RandBetween(2, Final))
While Cells(i, colonne2) <> condition
i = Round(Application.WorksheetFunction.RandBetween(2, Final))
While Cells(i, colonne3) <> condition
i = Round(Application.WorksheetFunction.RandBetween(2, Final))
While Cells(i, colonne4) <> condition
i = Round(Application.WorksheetFunction.RandBetween(2, Final))
While Cells(i, colonne5) <> condition
i = Round(Application.WorksheetFunction.RandBetween(2, Final))
Wend
Wend
Wend
Wend
tiragevide = Cells(i, colonne)
End Function |
Partager