Hello,

I am accessing a DDE link and I have a formula that calculates before the DDE updates the cell therefore an error appears in the formula. How do I make the macro pause until the DDE value has arrived in the cell so the formula can calculate properly. I do not want to do a time based solution either. Thanks, look forward to the replies! James