Need a little help with a sorting code

[colddeck84]

Hello guys
A few month ago i was luckily enough to receive help from a member here Jindon

he gave me this code:

Please Login or Register  to view this content.

Basically this code sort list taken from my sheet "matches" and sort it into columns in new sheet "lists" Its sorts countries in column A:A and row 1:1

The code is super fast but there is only one small hiccup with it because it does not sort the column "B: last column" A to Z

i've been using this workaround:

Please Login or Register  to view this content.

which is designed by me and is super slow. Unfortunately with my skill set its the best i can do :/
Any help to speed up this and maybe even dump the helper code would be great.

regards

frederik

[prabhuduraraj09]

Hi,

Probably try the below, by disabling the events and calculation. And re enabling them

[MarvinP]

Hi Frederick,

Simply comment out your For and Next lines. See what happens.

[colddeck84]

Hi and good morning. I tested code as suggested by prabhuduraraj09 gotta say it was super fast and exactly what I was looking for
My code load time has been greatly been reduced , much appreciated

[colddeck84]

You know my web puller script has gone from 15-30 sec load time. to 3-7 secs after this latest edit (also optimized something else)