Why generate a random number. Sounds like all you need is a unique number

? Format(now,"yymmddhhmmss")
040102150108



--
Regards,
Tom Ogilvy


Noctos wrote in message
...
yea the thing is the user will be doing this by thereselves so i won't
be there to keep on checking if the rand number to do. I think the best
way is to use vba. The rand number will be generated and this number
can be compared to the table using the match value if a value is found
then the rand number could be refreshed like a loop until a unique
value is found and this value is then displayed. Does anyone know how
to translate this into vba code


---
Message posted from http://www.ExcelForum.com/