Ok, so I have spent way too much time trying to figure this one out, so I'm turning to the experts! I am trying to create a macro that will take a selection of data, name it "Data", then use that selection as the source for my pivot table. Here is my code and I receive a Run-time 424: Object Required error at the bolded section...Can someone please tell me what I'm missing? Thanks in advance!
Please Login or Register to view this content.
Hi tbone3,
I'd start by using a Dynamic Named Range for the data to be used in the Pivot Table. See:
http://www.ozgrid.com/Excel/DynamicRanges.htm or
http://www.bettersolutions.com/excel...G820716330.htm
Then use the Named Range for the data in your pivot.
Hope that helps you write better code.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
@MarvinP : Why doesn't what I have in there now work (see code below)? I don't see how this addresses the pivot cache question? I apologize- I'm new at using vba to create pivot tables.
Please Login or Register to view this content.
Last edited by tbone3; 10-16-2013 at 03:48 PM.
If you are using 2010, it's simpler to use a Table, which works like a dynamic named range automatically.
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks