Sort VBA script - Column Ascendning

[a94andwi]

Hello

I need help with a script that sorts column C to BC in ascending order.
First Column C in ascending order. Then sort column D in ascending order. Then E and so on. Until column BC is sorted in ascending order.

I recorded the procedure but I think there may be simple loop to code instead which loops from one column til the last one. Is it possible?

Here is the code I have so far.

Please Login or Register  to view this content.

/Anders

[ImranBhatti]

Maybe like this.
Note: Try on a copy of the file

Please Login or Register  to view this content.

[a94andwi]

Perfect!!! It works just as I wanted!

Thanks.

[ImranBhatti]

Glad to have helped

[ImranBhatti]

If it solves the issue please mark your thread as "Solved" and as a good gesture press start button under the post which helped you.