Restrict Pivot Table VBA 1004 error

Good afternoon!
I have this VBA code that sometimes gives me a Run-time error '1004', but not everytime. When I click Debug the first item under "With pf" is highlighted, but I don't know how to fix. Can anyone help?

If it helps, I got this code from: http://www.contextures.com/xlPivot12.html#Restrict

Please Login or Register  to view this content.

As always, many thanks for your help!
N

I don't mean to push on this, but I really need to get this report out yet today, if at all possible.

Thank you so much!
N

Can anyone find an error in the code below, or a reason for the run-time error?

Thank you,
N

Originally Posted by NMullis

Good afternoon!
I have this VBA code that sometimes gives me a Run-time error '1004', but not everytime. When I click Debug the first item under "With pf" is highlighted, but I don't know how to fix. Can anyone help?

If it helps, I got this code from: http://www.contextures.com/xlPivot12.html#Restrict

Please Login or Register  to view this content.

As always, many thanks for your help!
N