run a macro when a range of cell are changed

[matwork]

Hi. can anyone help me please?

I have the code below but isn't working

Private Sub Worksheet_Change(ByVal Target As Range)
If (Target.Address = Sheets("Pivot").Range("l7:r43")) Then
Call ThisWorkbook.Macro1
End If
End Sub



Thanks

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[matwork]

Maybe:

Please Login or Register  to view this content.

Hi. it didn't work. The cell already have a value and i changed the value, but the macro didn't run