Hello,

When I use the code
ActiveCell.FormulaR1C1 = "=blp(blabla)"
The cell is populated with the data only after the whole macro is finished.
I do a cut and paste by values with the populated cells to tinker with the
data, but because the data is not loaded until the macro is done running, i
only get a bunch of #N/As for my values. Is there a way to keep the macro
from proceeding until it is certain that all the cells with formulas have
been populated with actual data? thank you/