|
-
May 2nd, 2008, 03:55 PM
#1
Thread Starter
Frenzied Member
Displaying Pivot Table items with a loopy loop
So I have a pivot table with a date filter. I want to only display the dates that are within the last 63 days. Sinch! Just a freakin loop adding negatives.
However, some of these dates have a time after them.
So what I need to figure out, is can I have some sort of wild card or Left() integrated into the loop.
Here is what I have, and would work if my data souurce didn't suck.
Code:
For i = -1 To -63 Step -1
ActiveSheet.PivotTables("PivotTable3").PivotFields("LST_XP_DAT").PivotItems(CStr(DateAdd("d", i, Date))).Visible = True
DoEvents
Next
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|