View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.interopoledde,microsoft.public.excel.programming
Dick Kusleika Dick Kusleika is offline
external usenet poster
 
Posts: 179
Default Events for cell deletion

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.