Thanks for the info......now sorted


"Tushar Mehta" wrote in message
m...
For a few different options see
Random Selection
http://www.tushar-mehta.com/excel/ne...ion/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
ional says...
I have a list of place names in column A from row 1 to row 56
Its part of a game so all I want to do is alter the order of names
(randomly
if possible)
There is only one column which is the one with the names in it.

thnaks