| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change event question
the Worksheet_Change event detects if any cell changes its value, and
assigns this cell to the variable "Target". Thats very good. My problem is, when I select a range of cells, then press "Delete" to empty these cells, only the upper left most cell in the range is detected to be changing its value, and only this cell initiates the Worksheet_Change event. This is bad because all the cells in the selected range have changed their values and the event procedure didn't detect them all. Any Suggestions? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet_Change Event with Range Protection | Excel Discussion (Misc queries) | |||
| Disabling WORKSHEET_CHANGE event | Excel Discussion (Misc queries) | |||
| Controling the Worksheet_Change Event? | Excel Discussion (Misc queries) | |||
| xl97 and Worksheet_Change event ? | Excel Programming | |||
| Worksheet_Change Event Not Working | Excel Programming | |||
Threaded Mode
