Hi Guys,
I have the following code which triggers a Macro if the value of cell A59 is greater than 1. However it only works if I select cell A59 and press enter. Yes I have the Calculations options set to automiatic. The formula does update automatically in cell A59, it just doesn't trigger the Macro until as I said above I select the cell and press enter to refresh formula.
Help please.
I have the following code which triggers a Macro if the value of cell A59 is greater than 1. However it only works if I select cell A59 and press enter. Yes I have the Calculations options set to automiatic. The formula does update automatically in cell A59, it just doesn't trigger the Macro until as I said above I select the cell and press enter to refresh formula.
Help please.
Code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Cells.Count > 1 Then Exit Sub
If IsNumeric(Target) And Target.Address = "$A$59" Then
Select Case Target.Value
Case Is > 1: InsertRowsOnValue
End Select
End If
Application.Calculation = xlCalculationAutomatic
End Sub