Hi everybody,
I have the following code which is working well on a single cell ,,but it is showing an error message with multiple selection.
Can You please summerize the range area (D5:E11) if that is possible and make the code working properly with more than one cell.![]()
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 4 Or Target.Column = 5 And Target.Row >= 5 And Target.Row <= 11 Then If Target = "" Then Target = 0 End If End Sub
Thank you,
Bookmarks