Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel page width in pixels?
I am setting up a formatted sheet to be a purchase order and am placing
several shape objects and such. It would be helpful to know the maximum number of pixel that will fit onto the printed page; of course depending on the page setup... paper size, margins, etc. Somewhere Excel decides whether a column will fit in the page area or print on another page. Is there an object that exposed this value? or even the paper size in inches? I tried to calculated it myself with numOfChars = (Application.InchesToPoints(8.5) - (leftmrgn + rightmrgn)) / (Application.StandardFontSize) which incorrectly yields the value 46.1, when I can actually fit much more. Also the .StandardFontSize is calculated on the present fonts "0" char. Is it possible to find that number. GOALS: to be able to place items relative to the right margin to be able to determine how many formatted columns I can fit on the page; eg. Columns("A:E").width = pagesize / 5 any help would be appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can we change units of column width to pixels? | Excel Discussion (Misc queries) | |||
column pixels vs column width | Excel Discussion (Misc queries) | |||
some columns 30 characters 155 pixels others 310 pixels why | Excel Discussion (Misc queries) | |||
Excel: Paper Page Width | Excel Programming | |||
Column width in pixels how? | Excel Programming |