Pivot Table Script Change

I have this pivot table script that was working fine in another workbook.

But then I needed it to run only on the last sheet of another workbook. So I took out "For each ws in worksheets" now I am getting an error "object variable or with block not set"

Not sure what happend?

Any Idea's?

Here is the code, Thanks for helping, Mike

Please Login or Register  to view this content.

Try this,

Please Login or Register  to view this content.

No problem