I come to a point in my VBA code where an array formula is calculated and it
pulls data from a DDE link, so the calculation is not always instantaneous
as it takes a few seconds to retrieve the data. In the meantime the program
continues to step forward and I am getting an error message at a point where
I am trying to assign a value to a variable based on a cell that is
dependent on the aforementioned calculation of the array formula.

I first tried just using a message box to freeze the program long enough for
the array formula to compute, but it froze it froze the array formula too,
so no help there. So, I sort of feel like a dog chasing its tail here. I am
not certain I know what I need but some sort of code after this:

Selection.FormulaArray = MySecondFormula

where the program pauses until the array formula has pulled its data in from
the DDE source and calculated the cell values, then as the code continues to
step forward, there would be a value where and when I need it to pass along
to the variable. I only get an error now.

My thanks in advance for any suggestions.

Cheers! Brad