Laurence D
New Member
- Joined
- Sep 14, 2016
- Messages
- 31
Hi there,
Can somebody please help me refine my code so that when I delete cells in column C and D at the same time that I will not produce a run-time error 13 mismatch. Just because I have six other people using this sub and they have zero knowledge or VBA or resetting a sub.
For context the rest of my code will auto-populate the same row in column D when a value is entered into column C.
I tried adding this code to no avail:
Thanks,
Laurence
Can somebody please help me refine my code so that when I delete cells in column C and D at the same time that I will not produce a run-time error 13 mismatch. Just because I have six other people using this sub and they have zero knowledge or VBA or resetting a sub.
For context the rest of my code will auto-populate the same row in column D when a value is entered into column C.
Code:
If Target.CountLarge > 3 Then Exit Sub
If Target.Column <> 3 Then Exit Sub
If Len(Target.Value) = 0 Then Exit Sub
I tried adding this code to no avail:
Code:
If Len(Target.Value) = 0 And Len(Target.Offset(, 1).Value) = 0 Then Exit Sub
Thanks,
Laurence