View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Yandl[_3_] Steve Yandl[_3_] is offline
external usenet poster
 
Posts: 117
Default 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?