CenterVertically Property
True if the sheet is centered vertically on the page when it's printed. Read/write Boolean.
Example
This example centers Sheet1 vertically when it's printed.
Worksheets("Sheet1").PageSetup.CenterVertically = TrueTrue if the sheet is centered vertically on the page when it's printed. Read/write Boolean.
This example centers Sheet1 vertically when it's printed.
Worksheets("Sheet1").PageSetup.CenterVertically = True