Page Set Up via code

[JoseSharp]

Hi, I am using the Dbs to report information to excel. The users want the excel workbooks formated. On each worksheet I have page set up coding but only the first page works the remaining two are not formated. The code is:

'change page setup
.PageSetup.Orientation = xlLandscape
.PageSetup.FitToPagesWide = 1
.PageSetup.FitToPagesTall = 1

Does anyone know a better way to do this or why the code is not formating correctly