You will need to generate a random number, which is easy, but you will need
to compare it against all others used, so you will need to store them all
somewhere. As simple incrementing number as Andy responded on seems easier
to me.

--
HTH

Bob Phillips

"Thomas Cox" wrote in message
...
I am creating an Invoice template in which I need it to generate a unique
random number each time the spreadsheet is opened. Anyone have any ideas
that I could try? Thanks
Tom