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.
Example
This example sets a variable for the distance from the top of the spreadsheet window to cell A35.
t2 = Spreadsheet1.Range("A35").Top