I am writing financial market software to look at spreads, and since the charting software vendor I am using does not support their DDE interface, I have to concatinate the formula into the spreadsheet and then take values from that. Application.wait just makes excel wait, and since i do not normally program in vb, nor can i find any good references, I am posting here. Anyone have ideas?