Hi,
Update....if you want a totally random look to your grid then try the
following once you have your grid set up the way I mentioned before.
Copy and paste over the grid using the "paste special" option and
selecting "values", this will get rid of the formula and leave you with
numbers only.
Now insert random numbers directly to the left or right of the grid by
using the =RAND() formula and then draging down, then select and sort
your grid using the random numbers. You can do the same with your
columns by using the same formula directly above or below the grid and
sorting from left to right instead of up and down.

Hope this helps!
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=475189