Run-time error '1004' help. Thank you

Hi all,

I'm attempting to write a macro that puts data into a pivottable automatically. This seems pretty simple, but I can't quite figure it out. I think there is a problem with the name of the table and location its going to? I'm not to sure. I'm getting the Run-time error '1004' Application-defined or object-defined problem or run-time error '5' Invalid Procedure Calls or Argument. Thank you for the help. Here is the code:

Please Login or Register  to view this content.

Thanks again

Welcome to the board, Tommy.

Please take a few minutes to read the Forum Rules, and then edit your post to wrap your code with CODE tags.

Thanks.

EDIT: While you're reading about that, please also read the rules about cross-posting: https://www.mrexcel.com/forum/excel-...thank-you.html

There are very good people on both sites. Just post links so people don't waste time working on something that's been solved elsewhere.