Ed,

Install the Analysis Toolpack add-in
Tools - Add-ins and check off the "Analysis Toolpack".
You might need your install discs depending on your installation.

Once complete you can use the RANDBETWEEN worksheet
function, which does exactly what your asking for.

Dan E

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