| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change page orientation to suit selection
MsgBox Selection.Height & " high by " & Selection.Width & " wide"
Steve Yandl "Liz" wrote in message ... I have a macro to quickly print the selection. In order to get the maximum sized print, I would like to change page orientation to maximise it. Is there any way to find the size of the selection so I can get the height / width ratio? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AutoFilter Selection to Change Page Header | Excel Programming | |||
| change default page orientation from portrait to landscape | Excel Discussion (Misc queries) | |||
| Why does my page orientation change when I print? | Excel Discussion (Misc queries) | |||
| Page Orientation | Excel Discussion (Misc queries) | |||
| what is the page orientation in Excel and how do you change it? | New Users to Excel | |||
![Steve Yandl[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
