Is there any way I can add a default value of "Hit" to the following
Sandy

With .Validation
.Delete
.Add Type:=xlValidateList, Formula1:="Hit,Miss"
.IgnoreBlank = True
.InCellDropdown = True
End With