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!
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?
Something like this:
Please Login or Register to view this content.
Last edited by romperstomper; 06-09-2014 at 08:23 AM. Reason: typo
Remember what the dormouse said
Feed your head
Thank you for the reply! I put in your code and it says there is a syntax error? Any thoughts?
Apologies - there was a missing quotation mark which I have now added.
Thank you so much! The code works exactly how I wanted it! Great job!
Glad to help. Please remember to mark the thread solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks