Hello

I have been struggling with the problem of how to make a event based macro work.
Hope someone out there know how-to. I'm a beginner in VBA, and new to this forum.

Behind cell R47 is a formula which display a number if a condition is meet, or nothing if it isn't. In case the number is more than 1, a macro is supposed to kick off. The macro is doing a simple task of copying and pasting an area, and has the side effect that the number in R47 disappear, but only until data from the net result in another figure in R47,(and trigger the macro again) . The problem is only....nothing happens.
I will be happy if someone has suggestions. The code:

Private Sub Worksheet_Change(ByVal Target As Range)
      
      If Range("$R$47").Value > 1 Then
      
      Macro1
    
    
    End If
    End Sub