Calculate doesn't finish

Hi, I have a large spreadsheet with lots of rows with formulas, so what I do is in a macro calculate and then copy and paste values in order to get Excel works faster.

Please Login or Register  to view this content.

What happens is that in a PC that is slower than the rest we have in the office, the values are pasted before calculation ends. This occurs only in formulas that makes a vlookup on a big set of data, other formulas with smaller vlookup work fine. As a result, the values pasted in certain columns are wrong.

Does anyone know how to force the calculation ends before it gets the next VBA instruction?

You can try:

Please Login or Register  to view this content.

I won't say I've had good luck with this, but sometimes it does the trick.