| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet calculation target cell
Excel 2002, WinXP
I have an OP who is getting stock updates through a Dynamic Data Exchange (DDE). He has a column of formulas that pull down the data. He wants something to happen when the contents of each of these cells change and that "something" needs to be tied to the particular cell that changed. Therein lies the problem. Obviously the content of the cell (a formula) has not changed so I can't use a Worksheet_Change macro to home in on the cell that changed. The only event that fires that I know of is the "sheet calculate" event, and that event does not identify the cell that triggered the calculation. I feel that I'm not the first one to come up against this problem, but I can't find anything on it. Does anyone know of some methodology by which to identify the cell that caused the calculation to fire? Thanks for your help. Otto |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
| Changing target sheet name wihtin a macro | Excel Discussion (Misc queries) | |||
| Hide/unhide sheet macro based on cell calculation | Excel Programming | |||
| copy to another wb and name the target sheet (XL2000) | Excel Programming | |||
| copy to another wb and name the target sheet (XL2000) | Excel Programming | |||
Threaded Mode
