Tushar provided a great link:

http://www.tushar-mehta.com/excel/ne...ction/vba.html

--
Regards,
Tom Ogilvy

"Excel Problems" wrote in message
...
Tom,
Many thyanks but you sugest writting my own routine, can you provide
example
of a routine please

thanking you in anticipation regards

Bernie

"Tom Ogilvy" wrote:

Randbetween does not generate unique random numbers. Just random
numbers.

the solution would be to write you own routine to generate unique random
numbers or query Google for posts in this group where such code has been
produced many times.

http://groups-beta.google.com/advanced_search

--
Regards,
Tom Ogilvy


"Excel Problems" <Excel wrote in
message
...
I have used the Randbetween calculation in four columns, however on a
few
occasions the same number is predicted in two different columns, how
can I
overcome this problem