Optimize VBA Code without Copy&Paste

Dear Community,

See Attached File.

I have Jindon's code for "Sorting", but I'm trying to Loop through each column list, copy&pasting into Jindon's code for "Sorting".



Why does Version1() macro work 100% fine (but takes 3 seconds per loop), but Version2() macro does not work at all, and gets poopy results?

Please Login or Register  to view this content.

Trying to OPTIMIZE with Version2()

Please Login or Register  to view this content.

I'm trying to Optimize the Version1() macro to eliminate any inefficiency, such as elimianting copy&paste, because I calculate it may take 26 hours to do 16,000 loops at 3 seconds each.

Try

Please Login or Register  to view this content.

Jindon,

May you and your entirely family be BLESSED with good fortune, prosperity, love, and happiness by God for generations upon generations.... for all of eternity.

You literally saved my life.

Dear Jindon,

I got really excited but I noticed the Sorting is like this:

a1
a2
a3
b1
b2
b3
c1
c2
c3

Could you sort it like this?

a1
b1
c1
a2
b2
c2
a3
b3
c3

jindon,

My Professor says he is gracious and very appreciative of all the help you given us! Thank you so much! You are #1 the best, God bless you!

Dear Jindon,

Sorry to bring this up again, but For the past 14 days, I worked tirelessly trying to get this code to run for my Professor...I'm super desperate.


The code you gave me worked very well for small number of columns (~10 columns), but at larger number of columns (15,000 columns), it just doesn't really work (data isn't copy and pasted)


I don't know why it works with 10 columns, but for 15000, it finishes, but the data doesn't appear to be sorted? (i'm thinking my code is not well optimized)
See below attached file:

Originally Posted by jindon

Just tested in Sheet2 and all is working fine.
If it goes 15000 columns, it may get slower, but it should work still.

I'm crossing my fingers but Jindon, you are right, the code DOES work.

I switched to another laptop (32bit Excel), and it works flawlessly, even up to 16,000 columns

My "gaming laptop" (64bit Excel) just crashes, maybe I need to do a fresh-reinstall of entire Windows or Excel! Irony is that my other laptop sucks, yet it can perform 16K columns just fine

Thank you so much Jindon for giving me the idea to try another laptop. I was going insane....

God bless you Jindon, I LOVE YOU for all the help you give me :-)