Posted to microsoft.public.excel.programming

external usenet poster

Posts: 26

Group Dates with Code

Hi Booshi

This code will let you group the dates the way Tom
suggests. You can find a full explanation in the VB HELP
under GROUP METHOD look in the range object explanation.

PT.PivotSelect "date[All]", xlLabelOnly

Selection.Group Start:=True, End:=True, Periods:=Array
(False, False, False, _
False, True, False, True)

where PT is a global variable set to the current pivot
table.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Group Dates	Dave	Excel Discussion (Misc queries)	3	August 28th 09 01:57 PM
group of dates	Savio	Excel Discussion (Misc queries)	1	January 31st 09 08:03 PM
Group Dates from SQL Query	wjvii	Excel Discussion (Misc queries)	1	March 22nd 07 11:52 PM
PivotTables - Group Dates, excluding dates	Todd1	Excel Discussion (Misc queries)	4	December 10th 05 05:06 PM
Group dates by month	jigsaw2[_2_]	Excel Programming	2	September 8th 03 04:00 PM

All times are GMT +1. The time now is 04:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us