- Ask the user for a positive integer (num), below 100.
- If the user enters a negative number or greater than 100, give a warning and ask to re-enter.
- Generate 20 positive random numbers between (1- num).
- Display the generated random numbers in the range (A1, A20).
I know there are random number generator functions in excel, but is there a way to do this without predefined functions in vba?
Thanks so much for any help!