ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change page orientation to suit selection (https://www.excelbanter.com/excel-programming/436281-re-change-page-orientation-suit-selection.html)

Steve Yandl[_3_]

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?





All times are GMT +1. The time now is 04:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com