Top Property

Top Property

See Also         Example         Applies To

Returns or sets the position of the specified object, in points. Read/write Long, except as shown in the following table.

Remarks

The meaning of the Top property depends on the specified object.

Object Meaning
Application The distance from the top edge of the screen to the top edge of the main Microsoft Excel window. If the application window is minimized, this property controls the position of the window icon (anywhere on the screen).
Range The distance from the top edge of row 1 to the top edge of the range. If the range is discontinuous, the first area is used. If the range is more than one row high, the top (lowest numbered) row in the range is used. Read-only.
Window The distance from the top edge of the window to the top edge of the usable area (below the menus, any toolbars docked at the top, and the formula bar). You cannot set this property for a maximized window. Use the WindowState property to return or set the state of the window.
Axis, AxisTitle, ChartArea, ChartObject, ChartTitle, DataLabel, Legend, LegendEntry, LegendKey, OLEObject, PlotArea The distance from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart). Read-only for Axis, ChartArea, LegendEntry, and LegendKey.