Applying code to specific cells when using worksheet_change?

New here and to VBA, but want code where result only applies to a range of cells . I have the following code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Value = "" Then
Target.Formula = "=iferror(vlookup(A15:a18,$A$21:$B$24,2,),0)"
End If

End Sub

But i want it to apply to cells C14:C19 only. currently if any other cell is overwritten and deleted it returns this formula too.

I hope this makes sense!

David

Hi
Try changing your second code line as follows:

If Not Application.Intersect(Target, Range("C14:C19")) Is Nothing Then

Good luck
Tony