Hi all, vba beginner here.
The below code is supposed to fill up cell F10 with the value when D10 is entered and vice versa.
But is is giving out error. Can someone point to me what is wrong?
Thanks in advance.
The below code is supposed to fill up cell F10 with the value when D10 is entered and vice versa.
But is is giving out error. Can someone point to me what is wrong?
Thanks in advance.
VBA Code:
Private Sub worksheet_change(ByVal target As Range)
If Not Intersect(target, Union(Range("D10"), Range("F10"))) Is Nothing Then
Range("D10").Value = (Range("F10").Value - 32) / 1.8
Range("F10").Value = Range("D10").Value * 1.8 + 32
End If
End Sub