I have the following short macro that I want to put in a worksheet activate
event.


Range("A9").Select
ActiveSheet.PivotTables("PivotTable4").PivotCache. Refresh
Calculate
Selection.AutoFilter Field:=3, Criteria1:="#N/A"

I keep getting Autofilter method of range class failed.

What do I need to change?

Thanks,
Barb Reinhardt