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.

Sheet16.Calculate
a = Hoja16.Range("A9").Resize(lastRow, 8).Value
Hoja16.Range("A9:H" & lastRow).Value = a
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?