Is there anyway to detect what cells have change value as a result of a Worksheet_calculate event. Worksheet_Change doesn't get fired for a calculation.
For example, I have cells that are updated from an external app (via DDE I think). When the update occurs I can trap it in Worksheet_calculate event, but I don't know what cell has been updated.
For example, I have cells that are updated from an external app (via DDE I think). When the update occurs I can trap it in Worksheet_calculate event, but I don't know what cell has been updated.