Excel 2000: Points vs. Pixels

[Mike Mertes]

Is there a way to set row height and column width in pixels, rather than in
points?

It appears that the .ColumnWidth/.Width and .RowHeight/.Height properties
operate only in points.

TIA!
-Mike Mertes

 

[Jon Peltier]

Hi Mike -

..ColumnWidth works in zeros, that is, the number of zero characters of
the default font. Most everything else goes by points. I've found the
conversion to be 0.75 points per pixel, 72 points per inch/96 pixels per
inch (96/inch is a standard pixel resolution). Different Windows
settings may affect this: I read recently that using large fonts changes
this to 0.8.

There are a couple of activewindow properties, PointsToScreenPixelsX and
PointsToScreenPixelsY, which tell you the dimensions of an object in
pixels, but I've never had it return any values other than zero.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______