Please help..

S

sameer27p

i want to change the page setup to landscape and margins to 0.25 in th
macro written in an excel sheet..does anyone have a macro code for thi
 
M

Mauro Gamberini

i want to change the page setup to landscape and margins to 0.25 in the
macro written in an excel sheet..does anyone have a macro code for this
?
Click to expand...


Public Sub MarginLandscape()

With ActiveSheet.PageSetup
.LeftMargin = Application.InchesToPoints(0.25)
.RightMargin = Application.InchesToPoints(0.25)
.TopMargin = Application.InchesToPoints(0.25)
.BottomMargin = Application.InchesToPoints(0.25)
.Orientation = xlLandscape
End With

End Sub
 
Top