Excel DDE Issue

[j_simon_blue]

I am trying to track the maximum value reached by a particular cell
which has is utilising a DDE link to update that cell with streamin
data.

Basically, what I am trying to achieve is this

If A1>A2 then replace the value in cell A2 with the value in A1.
If A1<A2 then A2 is not replaced.

I have tried to us the If function, but keep getting circular referenc
errors.

Any ideas