I created a macro that refreshes a pivot table when a Validation List is changed....it works fine with the below code. I have a second tab that needs to have the same refresh pivot table macro function when another validation list is selected...I used the same code below but inserted the macro name for this refresh and nothing happens....do I need to make additional changes to the code for this to work on another tab?


Private Sub Worksheet_Change(ByVal Target As Range)
Dim strMacro As String

'Do nothing if more than one cell is changed or content deleted
If Target.Cells.Count > 1 Then Exit Sub

If Target.Address = "$G$3" Then
strMacro = Target
Run "RefreshPandL"

End If

If Target.Address = "$G$5" Then
strMacro = Target
Run "RefreshPandL"

End If

If Target.Address = "$G$7" Then
strMacro = Target
Run "RefreshPandL"
End If

End Sub