Improve speed of Sort!

Hi, I just learned to do the copy and paste the fast way and my macros are thanking me for it.

Is their a way to improve the speed of a Sort?

Please Login or Register  to view this content.

This Sort is done thousands of times in a loop so any speed change is noticeable!


Any help is appreciated! Thanks.

Yes, using the Range.Sort method is faster than the Worksheets.sort method. But why are you sorting thousands of times in a loop? Wouldn't it be easier to just sort once after everything else is done?

Oh, I'm checking multiple combinations of lines in a list with some of them being constant. All lines have to be put in order of slope for the condition formulae to work.

Here's my macro I'm trying to speed up.

Can you see anything else I can change to make it faster?

Please Login or Register  to view this content.

You can get rid of the select statements. I also see you have application.calculation and application.screenupdating being updated during the loops instead of outside of the loops. You could set the sheets equal to variables instead of having the code define the sheet each time. But without knowing what your start looks like and what your desired end looks like, there's not much more advice I can offer. I also can't figure out why you need so many for loops. It seems incredibly inefficient.