T
tkt_tang
1. Enter an Excel Worksheet and select a range say, Cell E5.
2. Erase the contents of Cell E5 and the worksheet Change event is
fired.
3. And also ; Remove Cell E5 (albeit that it's replacement will follow
suit) and the worksheet Change event is fired as well.
4. The question is, how could it be possible to differentiate the
Erasure or Removal of Cell E5 by virtue of the Change event ?
5. Furthermore, what if, instead of a single cell, the affected range
of the Change event is multiple-cell, multiple-row or multiple-column ?
Could the respective conditions be coded to identify the resultant the
erasure or removal thereof ?
6. Please share your experience. Regards.
2. Erase the contents of Cell E5 and the worksheet Change event is
fired.
3. And also ; Remove Cell E5 (albeit that it's replacement will follow
suit) and the worksheet Change event is fired as well.
4. The question is, how could it be possible to differentiate the
Erasure or Removal of Cell E5 by virtue of the Change event ?
5. Furthermore, what if, instead of a single cell, the affected range
of the Change event is multiple-cell, multiple-row or multiple-column ?
Could the respective conditions be coded to identify the resultant the
erasure or removal thereof ?
6. Please share your experience. Regards.