PrintAcrossAndThenDown Property

PrintAcrossAndThenDown returns or sets whether multiple pages will be printed across rows first and then down (versus down columns first and then across) in a worksheet.

It has a Boolean value. If this value is set to 'True', the pages would be printed left to right first and then move down. If the value is set to 'False', the pages would be printed from top to bottom first, and then moves to the right and prints top to bottom again.

Syntax

object.PrintAcrossAndThenDown

object. PrintAcrossAndThenDown = Across

Parameter	Type	Description
Across	Boolean	required

Example 1

This example demonstrates how to return whether multiple pages will be printed across rows first and then down or down columns first and then across.

Debug.Print WksPageSetup.PrintAcrossAndThenDown

Example 2

This example demonstrates how to print multiple pages across rows first then down.

WksPageSetup.PrintAcrossAndThenDown = True

Used by: WksPageSetup object