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.