I am having issue adding pivot columns dynamically using vba. I am using a changing variable PV_Col as string that is feeding the source name to be added to the table. The code im using is:
err1004glob.GIF
Please Login or Register to view this content.
When I change the code to "worksheets" I get the following error :
err1004pvt.GIFPlease Login or Register to view this content.
Not sure what im doing wrong here, any help would be appreciated.
Check whether the value of PV_Col is exist in Pivot Table Filed.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
I apologize for delay, just getting at circling back to this, PV_Col works as a variable place holder for the actual column, therefore when running the macro my intention is to have a userform which holds all possible column headers as available options. Any value selected matches the value pulled from using ex: "headername = ctl.Name". For whatever reason i am able to successfully clear all the selected values programatically, but it is the adding the specific pivot columns that does not work. any code generated by running the macro recorder does not seem to flow through when applying a scripted aproach.
I fixed the above line for you. Unless you have checked and verified thats the case you cannot be sure it actually is. Add a debug.print line to output the value stored and/or put a watch on the variable and step through your code. As we only have 2 lines from your whole macro to help you by, we cant be certain something else isnt complicating things.Originally Posted by penbeacho
Also the difference between Sheets and Worksheets is important to understand. Additionally you are implicitly using them both, does your macro work between workbooks or only in a single workbook? You may consider explicitly adding the parent workbook before it: IE: workbook.worksheet...
Also what are the ,"FEE" and xlSum after that line? I cant find it documented anywhere.
Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.
"I am here to help, not do it for people" -Me
The "should" matches every time I have tested, but due to errors I couldn't confirm 100%.
"Fee" is the column header value.
xlSum is the Pivot Table value Excel attaches to the sum function inside the pivot values.
when it comes to sheets and worksheets there will be cross sheet moving within the same workbook, I have just been having a rough time trying to get by whatever means this part of the script to work. below is my current test bed code with several commented out approaches. The value of j is determined by a checkbox selection.
Please Login or Register to view this content.
Last edited by penbeacho; 02-23-2018 at 12:40 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks