av8tordude
12-14-2013, 09:40 AM
I have this code that applies a formula to a number I input. If cell is moved, I have to change the code to the cell I moved it to. How can I adjust it to lookup a specific word in column B and then apply the formula? Thank you for your help
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Cells = Range("D10") Then
Target.Value = Target.Value / "3.65"
End If
Application.EnableEvents = True
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Cells = Range("D10") Then
Target.Value = Target.Value / "3.65"
End If
Application.EnableEvents = True
End Sub