VBA Code to Refresh Pivot If One of Two Cell Values Change

[trypsin25]

Hello! I am attempting to update code to refresh a pivot table if one of two cells values change. I have tried (unsuccessfully) to write an OR statement in the below. I would like to add that if the value changes in cell E6 or C32 the pivot will refresh. Any help appreciated!!!!

Sub Worksheet_Change(ByVal Target As Range)
        If Target.Address = Worksheets("CoExOverview").Range("C32").Address Then
        ActiveSheet.Unprotect Password:="XXXXXX"
        PivotTables("Summary").RefreshTable
        ActiveSheet.Protect Password:="XXXXXX"
        End If
End Sub

 

[Anthony47]

I assume that the above code is inserted into the Class Module of worksheet CoExOverview; if it's true then you should use, for example

Sub Worksheet_Change(ByVal Target As Range)
        If Target.Address = "$C$32" Or Target.Address = "$E$6" Then
        ActiveSheet.Unprotect Password:="XXXXXX"
        PivotTables("Summary").RefreshTable
        ActiveSheet.Protect Password:="XXXXXX"
        End If
End Sub

Bye