i am trying to set the page layout option when i cliack a 'print' button on my form.
moment it makes a selection on a sheet and prints that selection. i want it to fit to screen and be landscape as well as
include column titles.
for some reason the landscape request is working but the fit to screen doesn't.
also, the column title are returned as 'a,b,c,d,e...etc' instead of my actual column titles.
here's what i've got
.PrintTitleColumns = "$A:$K"
.Orientation = xlLandscape
.FitToPagesWide = 1
.FitToPagesTall = 1
Selection.PrintOut Copies:=1, Collate:=True
can anyone help...pleeeease.