Export (0) Print
Expand All

Worksheet.ConsolidationOptions Property

Office 2007
Returns a three-element array of consolidation options, as shown in the following table. If the element is True, that option is set. Read-only Variant.

Syntax

expression.ConsolidationOptions

expression   A variable that represents a Worksheet object.

Remarks

ElementMeaning
1Use labels in top row
2Use labels in left column
3Create links to source data

Example

This example displays the consolidation options for Sheet1. The list appears on a new worksheet created by the example.

Visual Basic for Applications
Set newSheet = Worksheets.Add
aOptions = Worksheets("Sheet1").ConsolidationOptions
newSheet.Range("A1").Value = "Use labels in top row"
newSheet.Range("A2").Value = "Use labels in left column"
newSheet.Range("A3").Value = "Create links to source data"
For i = 1 To 3
    If aOptions(i) = True Then
        newSheet.Cells(i, 2).Value = "True"
    Else
        newSheet.Cells(i, 2).Value = "False"
    End If
Next i
newSheet.Columns("A:B").AutoFit



Community Additions

ADD
Show:
© 2014 Microsoft