Another question on detecting DDE updates

[sooznaid]

I was advised to use the following code but I get a Runtime error.. "Object not found"

Am I supposed to have customised this Hunk O'Code to something unique about my DDE parameters?

regards
Adrian


Use a Change Event macro which tests for a:

Private Sub Worksheet_Change(ByVal Target as Range)
If Target.Application.DDEAppReturnCode = True Then
MsgBox "Dynamic Data Exchange"
End If
End Sub