Sorting Multiple Columns

**Logit** · 12-26-2016, 03:47 PM

Using the macro recorder, the following generated code works very well for sorting columns A - Y:

Please Login or Register  to view this content.

Trying to consolidate all of that into something more compact, this is the result:

Please Login or Register  to view this content.

That macro goes through all the columns but only sorts on the last one. How do I correct my error ?

**Winon** · 12-26-2016, 04:23 PM

Hi Logit,

Please see this Thread; http://www.excelforum.com/l/743972-asdf.html

You should be able to adjust the Code to fit your needs if you so wish.

Please Login or Register  to view this content.

Regards.

**Logit** · 12-26-2016, 04:42 PM

BINGO !!

Thanks Winon.

**Winon** · 12-26-2016, 07:21 PM

Hello Logit,

You are welcome, glad I could help a bit.

Thank you for the Rep, much appreciated.!

Kind Regards,

W.

Re: Sorting Multiple Columns