Skip to content

Latest commit

 

History

History
48 lines (29 loc) · 1.13 KB

File metadata and controls

48 lines (29 loc) · 1.13 KB
title PageSetup.FitToPagesWide property (Excel)
keywords vbaxl10.chm473083
f1_keywords
vbaxl10.chm473083
api_name
Excel.PageSetup.FitToPagesWide
ms.assetid 162bd2d2-35fa-8133-ab1c-27dcfc173317
ms.date 05/03/2019
ms.localizationpriority medium

PageSetup.FitToPagesWide property (Excel)

Returns or sets the number of pages wide that the worksheet will be scaled to when it's printed. Applies only to worksheets. Read/write Variant.

Syntax

expression.FitToPagesWide

expression A variable that represents a PageSetup object.

Remarks

If this property is False, Microsoft Excel scales the worksheet according to the FitToPagesTall property.

If the Zoom property is True, the FitToPagesWide property is ignored.

Example

This example causes Microsoft Excel to print Sheet1 exactly one page wide and tall.

With Worksheets("Sheet1").PageSetup 
 .Zoom = False 
 .FitToPagesTall = 1 
 .FitToPagesWide = 1 
End With

[!includeSupport and feedback]