The rand() function will change each time the sheet is recalculated (which
occurs after the sort). If you don't need the numbers in column F, then
just disregard them (or clear them after the sort). If you want feedback
that the sort was actually in some order, then you can past special values
before the sort as the others have suggested.

--
Regards,
Tom Ogilvy

"hotherps " wrote in message
...
I have a range of data
A11:DU298

I want to sort the whole range randomly Column F is null. The formula
=Rand() can be put in each cell in F. But when I did that and then ran
some different code. The function in F just kept changing randomly.

I only want to sort the range by random once and then run my unrelated
code.

Thanks


---
Message posted from http://www.ExcelForum.com/

OK I understand what all of you mean now. I wasn't getting it at first.

But let me ask you this

Is there a way I could simulate that the F9 (autocalc) function before
the sort runs?

Then I would not have to clear it or add it

Thanks to all


---
Message posted from http://www.ExcelForum.com/