J
JR
Hello,
I have this macro: (below), but for some reason I can not get it to run. I
am very new to this and I am missing a step. I copy this to the macro editor
in Excel, but when I go back to the worksheet and try to run the macro from
the dropdown menu there is nothing listed as a name?? Any help would be
great. I think I am not doing the steps correctly to insert the macro into
my worksheet.
Thanks JR
(ByVal Target As Excel.Range)
With Target
If .Address(False, False) = "A1" Then
If IsNumeric(.Value) Then
Application.EnableEvents = False
Range("B1").Value = Range("B1").Value + .Value
Application.EnableEvents = True
End If
End If
End With
End Sub
I have this macro: (below), but for some reason I can not get it to run. I
am very new to this and I am missing a step. I copy this to the macro editor
in Excel, but when I go back to the worksheet and try to run the macro from
the dropdown menu there is nothing listed as a name?? Any help would be
great. I think I am not doing the steps correctly to insert the macro into
my worksheet.
Thanks JR
(ByVal Target As Excel.Range)
With Target
If .Address(False, False) = "A1" Then
If IsNumeric(.Value) Then
Application.EnableEvents = False
Range("B1").Value = Range("B1").Value + .Value
Application.EnableEvents = True
End If
End If
End With
End Sub