Top Property
Top property as it applies to the ChartSpace, ChCategoryLabel, ChChartField, ChDataLabel, ChDataLabels, ChErrorBars, ChLegendEntry, ChPoint, ChSeries, ChTrendline, PivotAggregate, PivotAxisMember, PivotColumnMember, PivotDetailCell, PivotPageMember, PivotResultAxis, PivotResultColumnAxis, PivotResultDataAxis, PivotResultFilterAxis, PivotResultGroupAxis, PivotResultLabel, PivotResultPageAxis, PivotResultRowAxis, PivotRowMember, and PivotTable objects.
Returns (or sets, depending on object used) a Long that represents the top edge of the specified object. Read/write.
expression.Top
*expression * Required. An expression that returns one of the above objects.
Top property as it applies to the ChScrollView object.
Returns a Long that represents the top edge of the ChScrollView object. Read-only.
expression.Top
*expression * Required. An expression that returns a ChScrollView object.
Top property as it applies to the PivotData object.
Returns or sets a PivotRowMember object that represents the member immediately above the topmost visible summary row.
expression.Top
*expression * Required. An expression that returns a PivotData object.
Top property as it applies to the Range object.
Returns a Variant that represents the distance from the top edge of the spreadsheet window to the top edge of the specified range. This value can be negative if the range is above the visible range. Read-only.
expression.Top
*expression * Required. An expression that returns a Range object.
Top property as it applies to the Window object.
Returns a Double that represents the top edge of the specified window. Read-only.
expression.Top
*expression * Required. An expression that returns a Window object.
Remarks
The only time any chart element coordinate is writeable is during the AfterLayout event of the ChartSpace object. Outside of this event, the Top property is read-only.
Example
This example sets a variable for the distance from the top of the spreadsheet window to cell A35.
t2 = Spreadsheet1.Range("A35").Top
Applies to | ChartSpace Object | ChAxis Object | ChCategoryLabel Object | ChChart Object | ChChartField Object | ChDataLabel Object | ChDataLabels Object | ChDropZone Object | ChErrorBars Object | ChLegend Object | ChLegendEntry Object | ChPlotArea Object | ChPoint Object | ChScrollView Object | ChSeries Object | ChTitle Object | ChTrendline Object | PivotAxisMember Object | PivotColumnMember Object | PivotData Object | PivotDetailCell Object | PivotPageMember Object | PivotResultAxis Object | PivotResultColumnAxis Object | PivotResultDataAxis Object | PivotResultFilterAxis Object | PivotResultGroupAxis Object | PivotResultLabel Object | PivotResultPageAxis Object | PivotResultRowAxis Object | PivotRowMember Object | PivotTable Object | Range Object | Window Object
See Also | Left Property