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
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