Invalid procedure call or argument error response while running macro to set up pivot

nn some help! (I am pretty new at understanding excel vba code)

The workbook I'm working with has 5 tabs set up, Monday thru Friday. Each day, I copy and paste some data onto the appropriate sheet, then run a macro to set up a pivot table, which will in turn feed a chart.

Today I had to catch up, and was able to run Monday & Tuesday just fine, but when it came to Wednesday, I got an error response:
"invalid procedure call or argument".

Below is the part of the code it is referring me to:

Please Login or Register  to view this content.

Thanks for all your help

Assuming the table is to be in the same workbook, try removing the workbook name from the TableDestination argument and don't supply a table name (you might end up using the same name again).