Posted to microsoft.public.excel.programming

John Pierce John Pierce is offline

external usenet poster

Posts: 93

PivotTable

In the VBA code to generate a PivotTable, I have lines that say

..PivotItems("1/18/2009").Visible = False
..PivotItems("1/22/2009").Visible = False

Can I replace them with something that says don't show anything less
than a certain age
like don't show if item (date) is greater than Today() - 7.?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a PivotTable w/o selecting data in an existing PivotTable	Damian	Excel Discussion (Misc queries)	6	November 2nd 07 04:44 PM
How does one get the PivotTable report info that feeds another PivotTable report?	Toby Erkson[_3_]	Excel Programming	0	December 14th 04 10:00 PM
PivotTable - PivotTable Field name is not valid - error!	miker1999[_17_]	Excel Programming	1	June 10th 04 10:30 AM
Pivottable	Charles	Excel Programming	3	May 15th 04 03:11 AM
Creating a PivotTable Report from an Another PivotTable Report	bcpaulus	Excel Programming	1	January 8th 04 07:56 PM

All times are GMT +1. The time now is 12:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us