Please help..
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 -- Message posted from http://www.ExcelForum.com |
Please help..
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 ? 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 -- ---------------------------- Mauro Gamberini |
All times are GMT +1. The time now is 04:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com