It seems to me that the resolution of the column widths are to fine. You
should limit your column widths to only one decimal point precision. So
instead of 1.43 use 1.4. Or instead of 8.86 use 8.8.



"Gleam" wrote in message
...
I have a program which checks workbooks and corrects those errors which it
can correct. One check is on the column widths: Column A should be 1.43
characters wide and column G should be 8.86 characters wide. This works
fine
on 99% of the computers where it is used but we have one or two where if
you
change the width of column A to 1.43 it goes to 1.44, and for column G if
you
set it to 8.86 it goes to 8.89.

This means that the next time the check is run, the workbook is deemed a
failure.

The difference appears to be the screen resolution: on the computers where
it works the resolution is 96x96 dpi and on one of the duff ones it is 120
x
120.

If I set the column to the maximum 255 characters, the width in points is
1790 on the OK computers and 1841.6 on the duff one.

Is there a way to calculate what Excel will set the column width to for a
given screen resolution? Then I could measure the resolution and check if
the
column width is OK.

Can one change the resolution? If so, will this be for all programs or
just
for Excel? (or for this spreadhseet?)