Change Pivot Table Data Source to range A7: last record in F column

Hello Everybody!

Been having some trouble setting a new data source for a pivot table in VBA. Please refer to the code below for more details.

Please Login or Register  to view this content.

Any ideas? Thanks a lot everyone!

Hi
The first proble is the "F?" in your range. Correct this and see if it resolves your issue.
Tony

I'm aware that the F in the code is messing it up. It was just meant to be an example as opposed to actual code.

A7 in the range is known and doesn't change, but the end value in the range does change. I need the code to read through the F column and find the last value Ex. F89, so the range for the new record source would then be A7:F89, but the F value will change.

So I just need to know how to scan the F column for the last value and then plug it into the range for a new record source.

Does anybody know how to do this?

Thank you for the reply! I put in your code and it says there is a syntax error? Any thoughts?

Thank you so much! The code works exactly how I wanted it! Great job!