Print Selective Area

Dear All,

I am looking forwards to make a print by using VBA Code for selective area.

I have Sheet2.Range(AL2:AV34) to be selected and Print.

Print Properties,
A. Selection Print for given area.
B. Selection Area Fits in to the A4 paper as maximum as. (As Tall and Wide)
C. Print Orientation, Landscape

Regards,

Rahul

Which version of Excel are you using?

I am using Excel 2010.