I mean when right-clicking on a cell/range/row/column and selecting
"Delete...". That way it shifts the other cells/rows/columns closer to the
top left, but unfortunately it only gives a Change event containing the new
data in the range, which is pretty useless because I want to find out the
cells which were removed in the process. :-( Is there any other event I
can listen to or property I can check to find out what was in the removed
cells?
Thanks,
Aaron.
"Dick Kusleika" wrote in message
...
Aaron
Deleted as in Cleared Contents? If so, you can check whether the target
(the cell that was changed) is empty. Like this
Private Sub Worksheet_Change(ByVal Target As Range)
If IsEmpty(Target) Then
MsgBox "cell was deleted"
End If
End Sub
--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.
"Aaron Queenan" wrote in
message
...
Are any events raised when cells are deleted?
I have just tested in Excel, and I seem to get a Workbook_SheetChange
event,
and I expect the Worksheet_SheetChange and Worksheet_Change events work
as
well. The problem is that I can't find any information about what the
arguments mean when cells are being deleted.
Thanks,
Aaron Queenan.