I'd like to know if there is a way to make Excel feel the change of a cell value.
In particular the cell value I'm referring to, is the cell that displays the Pivot filter value.
I want to "do something" when I change the value of the Pivot filter (B1) but unluckily the Change seems to work only if the cell value is edited manually (typed).
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" Then