Is there anyway to fire the Worksheet_Change event on a calc

[Bopa]

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.

 

[Bopa]

Re: Is there anyway to fire the Worksheet_Change event on a

From what I can find in previous post (should have looked first!) It looks like I have to store a range of monitored cells, and on a calculate event check each cell to see if the value has changed.

Is this the only way? seems a bit cumbersome

 

[tusharm]

Re: Is there anyway to fire the Worksheet_Change event on a

The change event is supposed to fire for DDE changes, except when there is a bug in XL as in XL97 (http://support.microsoft.com/default.aspx?scid=kb;en-us;172832) That document also contains a suggested workaround.