Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Group and Outline by marco?

Hi all,

Is it possible to do group and outline by marco?

Thank in advance

--
Message posted from http://www.ExcelForum.com

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,173
Default Group and Outline by marco?

This is pasted from the VBA help on the 'group' method. There is also the
AutoOutline Method, Outline Object, ClearOutline Method, DisplayOutline
Property, etc

The Range object must be a single cell in the PivotTable field’s data range.
If you attempt to apply this method to more than one cell, it will fail
(without displaying an error message).

Example
This example groups the field named ORDER_DATE by 10-day periods.

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
Set groupRange = pvtTable.PivotFields("ORDER_DATE").DataRange
groupRange.Cells(1).Group by:=10, _
periods:=Array(False, False, False, _
True, False, False, False)


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"kaon " wrote in message
...
Hi all,

Is it possible to do group and outline by marco?

Thank in advance.


---
Message posted from
http://www.ExcelForum.com/



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 and outline gonevertical Excel Discussion (Misc queries) 0 September 9th 09 12:02 AM
Under data/Group&outline/group Bernard Excel Discussion (Misc queries) 1 July 2nd 09 01:02 AM
"Data Group and Outline Group" feature Limited to 8 levels MarekMG Excel Discussion (Misc queries) 3 May 25th 07 06:12 PM
Group and Outline Marsh New Users to Excel 2 January 27th 07 06:19 PM
Group and Outline Cara Excel Discussion (Misc queries) 1 October 10th 06 01:53 AM


All times are GMT +1. The time now is 09:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"