hI
I try subtracting column C from column D when call my macro by using function isempty but doesn't work.
so what I look for . for instance when select C2 & D2 and clear the values , then the cell E2 should be 0 .
any idea to achieve it please?
I try subtracting column C from column D when call my macro by using function isempty but doesn't work.
so what I look for . for instance when select C2 & D2 and clear the values , then the cell E2 should be 0 .
VBA Code:
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
If Target.CountLarge > 1 Then Exit Sub
If IsEmpty(Target.Column = 3 And Target.Column) = 4 Then
Application.EnableEvents = False
Call test
Application.EnableEvents = True
End If
End Sub