CenterVertically Property Example
This example centers Sheet1 vertically when it's printed.
Worksheets("Sheet1").PageSetup.CenterVertically = True