Cannot create a pivot table reference.

I have the following code to create a pivot table from a data set. I get a Reference is Not Valid at the red line below. I know the fix must be simple, but I have hit a blank on the fix.

Thanks in advance.

Please Login or Register  to view this content.

Hello GoPack1,

Welcome to the Forum!

Your post title should convey a brief description of what you need help with. Please do not use general words and phrases like "Help!", "Code doesn't work", "Urgent!", etc. Your present title doesn't tell anyone what your question is or what type of problems you are experiencing.

A better title would be "Error - Reference Not Valid when creating a Pivot Table".

As a new member, please take the time to read over the
Forum Rules .

Hello GoPack1,

Thanks for changing the title. I didn't notice from the first post that you're a Tarheel. As if GoPack1 wasn't a give away! I grew up in Asheville.