Pivot Table Script Problem

Hi,
I have used this script in the past with several worksheets and had no problems. I recently made some major changes to the worksheet I am now trying to run this on and now I have problems.

I first thought that all the code in the new sheet was causing a conflict so I thought I would try to remove all the code then try this script. However no luck...

I keep getting an error when trying to create the pivot table

Please Login or Register  to view this content.

I have attached the sheet I am running this script on to help whomever can help figure out what is wrong.

Thank You, Mike

Please Login or Register  to view this content.

It's probably due to the fact that the sheet being processed is not the one you think it is.

You loop through the sheets. First up is the Hidden LA sheet.
Change you code to use the "LA-05-01-09" worksheet only as the source of the pivot table.