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
Bookmarks