Hello Guys,
I got the following code
This is not working. Can somebody please point me to the mistake I am making in this code? What should I replace with what and why?
Also, if I wanted to make it worksheet calculate eevent where A1 will be result of A2+A3, how would I do it?
Asad
I got the following code
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Address <> "$A$1" Then Exit Sub
If .Value <> "" Then
Range("B1") = "Empty"
Else
Range("B1") = "Not Empty"
End If
End With
End Sub
Also, if I wanted to make it worksheet calculate eevent where A1 will be result of A2+A3, how would I do it?
Asad