Worksheet.ConsolidationSources Property

Syntax

expression.ConsolidationSources

expression A variable that represents a Worksheet object.

Example

This example displays the names of the source ranges for the consolidation on Sheet1. The list appears on a new worksheet created by the example.

Visual Basic for Applications

Visual Basic for Applications
`Set newSheet = Worksheets.Add newSheet.Range("A1").Value = "Consolidation Sources" aSources = Worksheets("Sheet1").ConsolidationSources If IsEmpty(aSources) Then newSheet.Range("A2").Value = "none" Else For i = 1 To UBound(aSources) newSheet.Cells(i + 1, 1).Value = aSources(i) Next i End If newSheet.Columns("A:B").AutoFit`

Set newSheet = Worksheets.Add newSheet.Range("A1").Value = "Consolidation Sources" aSources = Worksheets("Sheet1").ConsolidationSources If IsEmpty(aSources) Then newSheet.Range("A2").Value = "none" Else For i = 1 To UBound(aSources) newSheet.Cells(i + 1, 1).Value = aSources(i) Next i End If newSheet.Columns("A:B").AutoFit

consolidation sources Consolidation Sources Property Consolidation sources? ConsolidationSources ConsolidationSources Property List all sheets being used by the consolidation function? Source of information for averaging consolidation? What is the source of the data for my consolidation?

Worksheet.ConsolidationSources Property

Returns an array of string values that name the source sheets for the worksheet's current consolidation. Returns Empty if there's no consolidation on the sheet. Read-only Variant.

See also: