Hi I have asked this about four years ago and got sent the perfect
code but have since lost it :-(.
I have a list of items in the rows and prices in the columns, I have
four different prices in col C,D,E,F.
Eg. Item Code - Item Neme - Price 1 - Price 2 - Price 3 - Price4.
Now I need to bubble sort columns C.D.E.&F so that it mixes up the
prices in the columns without affecting the rows. In other words the
prices must stay within the row they are allocated to but randomly
change columns.
So by using code it must go from row to row and randomly sort the four
columns.
Whewww. I hope someone can help me again.
Megaman.