help with Sorting

[maju]

Can sorting go up to 6 keys? Key1, key2, key3, key4 …key6

I am trying to sorting 6 different column/row in ascending order.

if so, i need hep with the code.

Thanks

 

[Jim Cone]

Run the sort twice, keys 4,5,6 first then keys 1,2,3.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins - two dozen ways to sort with Special Sort)



"maju" <[email protected]>
wrote in message
Can sorting go up to 6 keys? Key1, key2, key3, key4 …key6
I am trying to sorting 6 different column/row in ascending order.
if so, i need hep with the code.
Thanks

 

[Joel]

You can do multiple sorts, but only three at a time. Do the less precedence
first

If you were sorting the number 6 5 4 3 2 1. One digit in each columns A - F.
sort D E F first. Then repeat using columns A B C.

 

[maju]

Thanks guys

You can do multiple sorts, but only three at a time. Do the less precedence
first

If you were sorting the number 6 5 4 3 2 1. One digit in each columns A - F.
sort D E F first. Then repeat using columns A B C.

 

[maju]

how do i determine the last cell and then sort the information. i dont wand
to hard code the ranges. because datas changes.