Sorting 100 rows of 6 records horizontally
I had already tried that but it only sorts the first 3
columns at the max
-----Original Message-----
perhaps you could transpose the 6cols x 100 rows to 100
cols x 6 rows, use
the columns.sort method (or some such) to sort each
column alone, then
retranspose to 6 x 100.
--
Bob Kilmer
"Victor" wrote in
message
...
I would like to sort the 6 records in each separate row
(100 total)
ascending.
Is there a built-in function to do that.
I tried to use the macro recorder to sort the rows
manually but 100 is too
tedious, I would appreciate any hints for a killer macro..
TIA
.
|