use the pagesetup of the range .PageSetup.FitToPagesWide
.PageSetup.FitToPagesWide
View Tag Cloud
Forum Rules