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

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"
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

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" wrote:

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

Thanks guys

"Joel" wrote:

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" wrote:

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

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

"Joel" wrote:

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" wrote:

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