Macro to Create Multiple Pivot Tables in Multiple Sheets with Dynamic Data Filter

[Kenneth Hobs]

Looks ok to me. Maybe your setting of the PT object did not set. Try a

Debug.Print PT.Name