Thread: Pagesetup.Orientation need VBA routine to "Best Guess" Orientation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] EagleOne@discussions.microsoft.com is offline
external usenet poster
  
Posts: 391
Default Pagesetup.Orientation need VBA routine to "Best Guess" Orientation
2003/2007

What parameters/settings with PageSetup could provide assist with calculating
PageOrientation to be placed in a macro to "best guess" it?

i.e. .Orientation = IIf (height 2 * width AND Columns.count < 9),"Portrait","Landscape")

Is there a way to use inches in the height/width calculation?

Is there a better approach?

TIA EagleOne
Reply With QuoteReply With Quote