Thanks a lot Bob - that works a dream. Just one thing - I found that to
re-calculate I didn't need to.......

"clear cell B1, edit cell A1, and copy A1 down to A10, and re-input
B1"

By leaving the value in B1 and simply copying A1 down to A10 I got my
new list of randon non-repeating numbers. I've also set it up as a
macro, so I simply press my keyboard shortcut each time for a new
list.

Once again - thank you !

Ian


--
IanW
------------------------------------------------------------------------
IanW's Profile: http://www.excelforum.com/member.php...o&userid=31366
View this thread: http://www.excelforum.com/showthread...hreadid=510576