=Trunc(rand()*100+1)
drag fill down for as many cells as you need numbers.

will generate whole numbers (not unique) between 1 and 100 inclusive.

--
Regards,
Tom Ogilvy

"ed" wrote in message
...
is there any way of only generating whole numbers within a
certain range with the rnd function