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