Hello,

You both had replied to my earlier post and I'm hoping you can offer me a
bit more of follow up (original post was for Target Value question). I'm
hoping you can help me more regarding the solution due to I'm not sure
exactly how to set it up. I've also enclosed my original macro and more
information and maybe this will help to clear up some of the confusion I
might have caused.
__________________________________________________ __________________
The Range below is the area monitored on the "Front Page". Data is pasted
over to this workbook onto the "Data Page" and is then linked to the "Front
Page" ( Front Page linked to Data Page "B5" Cell). Since the Front Page
entry will not always be the same cell row due to the previous paste places
the contents in next empty cell, I'm not quite sure how apply your post to
get the needed results (looks like it's always set to a particular watch
cell).

Thanks for you continued advice - Jenny B.


Private Sub Worksheet_Change(ByVal Target As Excel.Range)

If Not Application.Intersect(Target, Range("L18:L33")) Is Nothing Then
If Target.Value = 0 Then
Target.Offset(0, 0).Select
Selection.ClearContents
End If
End If
End Sub