Sort column by column using array

[daboho]

I have code from mick
To sort by col to next column
But this using range
How to change this code to array

Please Login or Register  to view this content.

How to change using array
Like this
But still error

Please Login or Register  to view this content.

[MickG]

One way !!!
The original code appears to be based on the sorting (ascending "Horizontal) of row 1 of "Rng"
The code below based on array "x" is also based on the first row being sorted.
Data based on columns "A to E" with Results starting "H1".

Please Login or Register  to view this content.

Regards Mick

[daboho]

thankyou very match Mickg is Perfect
i has try change your coding but result missing 1 column next day maybe can i try agaian
BUT THANKYOU VERY MATCH FOR YOUR HELP

Please Login or Register  to view this content.

mic1.png

mic2.png