Hi,
I am trying to loop through each pivot item in the pivot table filter called 'COMPANY_NAME'
This is the code I have so far but get an error on line 'PvItemL.Visible = False'
Can someone please give me a clue as to why this error comes up please?
Please Login or Register to view this content.
Thanks
Maybe tell us what you're trying to achieve? You have 2 loops looping the same field.
Let's say there are only three items in that field.
Please Login or Register to view this content.
多么想要告诉你 我好喜欢你
Thanks millz for your speedy response...
I have 7 pivot items which I want to loop through and check if C20 is greater than 20 and save as PDF if it's true.
I have taken out one of the for loops but still get the same error.
Any help?
Please Login or Register to view this content.
Well, removing one of the loops will still end up the same because you are still going to hide everything eventually.
The idea would be to make everything visible first in every loop, before hiding what you don't want to see. Try this:
Please Login or Register to view this content.
Thanks millz, your solution worked
One more question for the lineWhy do I get an error when I put ("C6:C9")?Please Login or Register to view this content.
Because you cannot compare a range of cells to a single value.
oh okay, thanks milllz that makes sense
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks