Export (0) Print
Expand All

Top Property

Office 2003

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.

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.

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.

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.

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
		


See Also | Left Property


Show:
© 2014 Microsoft