Hi Jacob,

No, I mean acutally deleting the cell, not just the contents. Delete
Shift cells up etc. Can this be determined?
--
Thanks for your help.
Karen53


"Jacob Skaria" wrote:

If you mean delete contents of a cell..

Private Sub Worksheet_Change(ByVal Target As Range)
If IsEmpty(Target) Then MsgBox "Trying to delete contents"
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Karen53" wrote:

Hi Jacob,

Thank you for your reply.

In doing this, won't it give me any change? How do I determine cells were
deleted?

--
Thanks for your help.
Karen53


"Jacob Skaria" wrote:

Karen, try the worksheet change event..(Right click the sheet tabview code)

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox Target.Address
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Karen53" wrote:

Hi,

Is there a way to catch when cells are deleted from certain columns of a
worksheet?
--
Thanks for your help.
Karen53