Slow running code

Hi,

I have pretty basic skills so wondered if anyone could help me please. I have written/recorded the following macro:

Please Login or Register  to view this content.

Although this works fine for it's intended purpose it is very slow to run (I am looping this macro thousands of times). I have tried cleaning up areas of it where I could but wondered if there was a way of coding this that would help it to run quicker.

Many thanks in advance for any help!

You may avoid selecting and if you must run the code in a loop there is no need to reset the sort fields within the loop - only apply the sort.

Phil2006,

Try switching the calculations to manual at the start of your code - then to automatic again at the end.
It will hang for a while at the end, but it will be much more efficient than recalculating after every change.

'Application.Calculation = xlCalculationManual

Application.Calculation = xlCalculationAutomatic'

Hi guys,

Thanks so much for a quick response! Sorry to be a bit basic but how do I avoid selecting if I need to use the data in the cells I had been using the select function for?

Kurt - Thanks! I have that done in the looping macro; the code looks like this:

Please Login or Register  to view this content.

Thanks again so much for helping

For example:

Please Login or Register  to view this content.

can be:

Please Login or Register  to view this content.

Thanks again Izandol! I have now removed all the Select functions as you suggested and it is improved. It is still taking a long time though, any more tips would be most appreciated - I do think that this can run quicker as I had a similar function previously that did the same job but was much quicker!

Thanks again for all your help so far, it is very appreciated!

Phil2006

Do you have any vlookup formulas, graphs etc on any of your worksheets? or are other worksheets sharing the data you are sorting?

It is difficult with only part of the code but you may try:

Please Login or Register  to view this content.

and:

Please Login or Register  to view this content.

I do not know if there is more code for Paste_Macro.

Thanks, I will try that now. My above post contains the full code for the macro. Some of the sheets do have a lot of formulae on (no vlookup) but holding the calculate button doesn't cause any problems and all formulae update really quickly so I wouldn't have thought that would be a problem.

Thanks again