Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Application.Width Property (Excel)

Published: July 16, 2012

Returns or sets a Double value that represents the distance, in points, from the left edge of the application window to its right edge.

expression .Width

expression A variable that represents an Application object.

If the window is minimized, Width is read-only and returns the width of the window icon.

This example expands the active window to the maximum size available (assuming that the window isn’t maximized).

With ActiveWindow 
 .WindowState = xlNormal 
 .Top = 1 
 .Left = 1 
 .Height = Application.UsableHeight 
 .Width = Application.UsableWidth 
End With
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.