Simple way to print in landscape VBA

[ben_sorensen]

Hello

I am trying to print in an excel sheet in landscape mode and think that there has to be a simple way of doing this, but maybe not and I just need somebody to help me with the page setup:

Here is the code that I have right now:

sub PrintGMReport ()

Sheets ("General Manager Report").PrintOut

End Sub

This does the job I just need to print it in Landscape mode.

Any help would be greatly appreciated.

Best
Ben

 

[MARK858]

Why not record it manually with the macro recorder and see what the code produced is?