Measuring Column Width

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Why does the following line of code return 48 rather the 8.43 when used on a
default column width?

MsgBox "Selected Column Width is " & Selection.Width

Martin In Texas
 
width is the number of points

use columnwidth to return 8.3
MsgBox "Selected Column Width is " & Selection.ColumnWidth

look up the columnwith property in help
 
Hi Martin,

The Width property returns the selected column width, in points.

The ColumnWidth property returns the width of the column using a unit equal
to the width of one character in the Normal style
 
Norman

Thanks

Martin

Norman Jones said:
Hi Martin,

The Width property returns the selected column width, in points.

The ColumnWidth property returns the width of the column using a unit equal
to the width of one character in the Normal style
Click to expand...
 
Gary

Thanks

Martin

Gary Keramidas said:
width is the number of points

use columnwidth to return 8.3
MsgBox "Selected Column Width is " & Selection.ColumnWidth

look up the columnwith property in help
Click to expand...
 
Back
Top