Hi,

I'm very new to VBA. I'm using a bit of code I got from another website to automatically copy some data from cell F3 to column D whenever a cell in column C is modified. I would like to make two changes to how it works:

1) I would like it to stop triggering whenever I delete something from column C.

2) I would like to stop it overwriting anything that may already be in column D.

Any help would be much appreciated, as I say I'm very new and don't really know what I'm doing yet.

Here's the coding:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.Count > 1 Then Exit Sub

        If Not Intersect(Target, Range("C6:C1000")) Is Nothing Then

            With Target(1, 2)

                .Value = Range("F3")

            End With

        End If

End Sub