Creating Pivot Table with VBA error 1004 Field not valid

Hi all,

I've been searching this forum and the rest of the web for quite some time now but I still haven't found a solution to my problem. I hope someone can help me.

I get the following error: "Run-time error '1004': The Pivot Table field name is not valid. To create a Pivot Table report, you must use data that is organized as a list with labeled columns. If you are changing the name of the Pivot Table field, you must type a new name for the field."

On this line of code:

Please Login or Register  to view this content.

The solution that is presented everywhere is that there is an empty hidden cell in the header row. I've checked this (multiple times) and this is not true. There are also no indentical cells in the header row. I can produce the pivot table manually, but I will need to perform this for several hundreds of files so I want to automate it.

This is my entire code:

Please Login or Register  to view this content.