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