In the following code I have 'FitToPagesWide' and tall = 1, but when run, it still shows up on two pages. What am I missing here?
Much thanks for any help.
Much thanks for any help.
VBA Code:
Sheets("Original").Select
Do Until ActiveSheet.Name = "zzz"
ActiveSheet.Next.Select
RowNum = Range("A10000").Offset.End(xlUp).Row
Range("a2:P" & RowNum).Select
If ActiveSheet.Name = "zzz" Then
Sheets("Original").Select
End
End If
With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$1"
.PrintTitleColumns = ""
.Orientation = xlLandscape
.FitToPagesWide = 1
.FitToPagesTall = 1
End With
Selection.PrintPreview
Last edited by a moderator: