put your numbers in column A

-----Original Message-----

I need help with this code.

1.)I need a VBA fnction that will take a fix set of
numbers, scramble
them, and never use the same number 2 times.

Its gotta be simple, but Ive never worked with random
generators in VBA
in B put the value =RAND()
calc the sheet and sort the table by column B
since the values in B are random, the sort is random


Patrick Molloy
Microsoft Excel MVP

before.

Please send help to

Thanks All.




------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by
step guide to creating financial statements
.