generate a random list with 3 options
Excel 2002
I am trying to generate a random list of three options "Poor", "Average",
"Good"
I do not want these numbers to change once they have been generated as they
will drive further options.
Tried to use something below and then use Vlookup to get the appropraite
response but its not what I am after.
Sub Generate_Year()
Dim i As Integer
For i = 1 To 100
With Worksheets("Year")
..Cells(3 + i, 1) = "=RANDBETWEEN(1,3)"
End With
Next i
End sub
I did try
..Cells(3 + i, 1) = Application.WorksheetFunction.RANDBETWEEN(1,3)
but it didn't work.
Any suggestions would be greatley appreciated.
|