Sign in

Home Products Office 365 Docs Samples Downloads Training How To Support Forums

Office and SharePoint development

Office client development

Office 2010

Excel 2010

Excel 2010 Developer Reference

Reference

Range Object

Methods

Range.Activate Method (Excel)

Range.AddComment Method (Excel)

Range.AdvancedFilter Method (Excel)

Range.AllocateChanges Method (Excel)

Range.ApplyNames Method (Excel)

Range.ApplyOutlineStyles Method (Excel)

Range.AutoComplete Method (Excel)

Range.AutoFill Method (Excel)

Range.AutoFilter Method (Excel)

Range.AutoFit Method (Excel)

Range.AutoOutline Method (Excel)

Range.BorderAround Method (Excel)

Range.Calculate Method (Excel)

Range.CalculateRowMajorOrder Method (Excel)

Range.CheckSpelling Method (Excel)

Range.Clear Method (Excel)

Range.ClearComments Method (Excel)

Range.ClearContents Method (Excel)

Range.ClearFormats Method (Excel)

Range.ClearHyperlinks Method (Excel)

Range.ClearNotes Method (Excel)

Range.ClearOutline Method (Excel)

Range.ColumnDifferences Method (Excel)

Range.Consolidate Method (Excel)

Range.Copy Method (Excel)

Range.CopyFromRecordset Method (Excel)

Range.CopyPicture Method (Excel)

Range.CreateNames Method (Excel)

Range.Cut Method (Excel)

Range.DataSeries Method (Excel)

Range.Delete Method (Excel)

Range.DialogBox Method (Excel)

Range.Dirty Method (Excel)

Range.DiscardChanges Method (Excel)

Range.EditionOptions Method (Excel)

Range.ExportAsFixedFormat Method (Excel)

Range.FillDown Method (Excel)

Range.FillLeft Method (Excel)

Range.FillRight Method (Excel)

Range.FillUp Method (Excel)

Range.Find Method (Excel)

Range.FindNext Method (Excel)

Range.FindPrevious Method (Excel)

Range.FunctionWizard Method (Excel)

Range.Group Method (Excel)

Range.Insert Method (Excel)

Range.InsertIndent Method (Excel)

Range.Justify Method (Excel)

Range.ListNames Method (Excel)

Range.Merge Method (Excel)

Range.NavigateArrow Method (Excel)

Range.NoteText Method (Excel)

Range.Parse Method (Excel)

Range.PasteSpecial Method (Excel)

Range.PrintOut Method (Excel)

Range.PrintPreview Method (Excel)

Range.RemoveDuplicates Method (Excel)

Range.RemoveSubtotal Method (Excel)

Range.Replace Method (Excel)

Range.RowDifferences Method (Excel)

Range.Run Method (Excel)

Range.Select Method (Excel)

Range.SetPhonetic Method (Excel)

Range.Show Method (Excel)

Range.ShowDependents Method (Excel)

Range.ShowErrors Method (Excel)

Range.ShowPrecedents Method (Excel)

Range.Sort Method (Excel)

Range.SortSpecial Method (Excel)

Range.Speak Method (Excel)

Range.SpecialCells Method (Excel)

Range.SubscribeTo Method (Excel)

Range.Subtotal Method (Excel)

Range.Table Method (Excel)

Range.TextToColumns Method (Excel)

Range.Ungroup Method (Excel)

Range.UnMerge Method (Excel)

Minimize

This topic has not yet been rated - Rate this topic

Range.Ungroup Method (Excel)

Office 2010

Office 2013

Promotes a range in an outline (that is, decreases its outline level). The specified range must be a row or column, or a range of rows or columns. If the range is in a PivotTable report, this method ungroups the items contained in the range.

expression .Ungroup

expression A variable that represents a Range object.

Return Value

Variant

If the active cell is in a field header of a parent field, all the groups in that field are ungrouped and the field is removed from the PivotTable report. When the last group in a parent field is ungrouped, the entire field is removed from the report.

This example ungroups the ORDER_DATE field.

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable 
Set groupRange = pvtTable.PivotFields("ORDER_DATE").DataRange 
groupRange.Cells(1).Ungroup

Concepts

Range Object Members

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.