Print Selective Area

[r_know]

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

[Excel Fox]

Which version of Excel are you using?

[r_know]

I am using Excel 2010.