Hi All,

So I am using a Macro to rank 124440 firms based on a return metric, given a specific period. The Macro I wrote is as follows:

Please Login or Register  to view this content.
So this Macro basically ranks the firms first, then copy/pastes the values to make Excel run faster afterwards. However, the process takes forever and I have never actually finished the calculations.

Is there a way to speed things up? Would setting calculate to manual help? In that case I would have to run the copy/paste macro separately I guess.

Or is there a way to have Excel do the ranking without first inserting the formula's in each cell? This would be the preferred solution.

Well, in any case, thanks alot!

Hieronymus5