Is there an option/ or a formula to generate random numbers without duplication...Currently i'm not storing the random generated numbers in the database.
Please help me..its quite urgent
You can use the below function to return a random number
Public Function GetRandomNumber(Upper As Integer, Lower As Integer) As Integer
'Generates a Random Number BETWEEN the LOWER and UPPER values
GetRandomNumber = Int((Upper - Lower + 1) * Rnd + Lower)
For preventing duplication you need to write seperate code to check each random number returned by this function against your the list of already used numbers.