Width property

[jim c.]

does anyone know of a way to convert the coulmn width
value returned on a worksheet into points that can be used
for column width for a listbox on a userform?

listbox rowsource is a named range.

Currently I use just the value returned to autosize
columns in my listbox, but of course is not accurate and
the differences are cumulative. I have 14 columns in
listbox and would like to regain wasted space between
columns to maybe eliminate having to horizontal scroll to
last column.

I appreciate your input. This is just a curiosity, not a
problem.

 

[jim c.]

I answered my own question.

Didnt realize that Range Object has a width property. Duh!