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.
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.
Left 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.
Left 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