I would like to retain the values derived from DDE formulas.
The situation is like this:
A1 = stock code
A2 - G2 = respective information(price,change,trading volume...)
Please Login or Register  to view this content.
The above code works. However, I need to use the same DDE formulas in row 3,4,5.....in order to record the data at different times. I need to keep the original values in A2-G2 so that the cells will not recalculate later because after all it is a formula, which will screw up the past data.

My requirements are (1) make the result in value rather than formula format (2) Do not use any other cells as intermediaries

I have a couple of ideas.
(1) copy and paste special values
Please Login or Register  to view this content.
(2) Force it into value format 
Please Login or Register  to view this content.
(3) Use array as intermediary
Please Login or Register  to view this content.
It all produced #n/a. There are rare occasions that the program works,but mostly failed. If I use F8 to run step by step, it works!

It really confused me. Is there any bullet-proof method? Thanks