Top Property
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
