_Worksheet.ConsolidationOptions Property
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 Object.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
ReadOnly Property ConsolidationOptions As Object
Get
'Usage
Dim instance As _Worksheet
Dim value As Object
value = instance.ConsolidationOptions
Object ConsolidationOptions { get; }
Property Value
Type: System.Object
Remarks
Element |
Meaning |
|---|---|
1 |
Use labels in top row. |
2 |
Use labels in left column. |
3 |
Create links to source data. |