Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I generate a list of random dates from dates I specify | Excel Worksheet Functions | |||
Generate random number from a list | Excel Worksheet Functions | |||
Need to generate random values from a list | Excel Discussion (Misc queries) | |||
generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
How to generate a random list of weekDAYS between two dates? | Excel Worksheet Functions |