Take a look at the worksheet method he

http://www.mcgimpsey.com/excel/udfs/randint.html

In article ,
Jane@Rakiraki wrote:

I have a spread sheet with 10, 000 numbers on it. 1 - 10000. I need to
jumble all the numbers up to make them completely random. Has anyone any
ideas how do this on such a scale?

Thanks