Measuring Column Width

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
 
G

Gary Keramidas

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
 
N

Norman Jones

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
 
G

Guest

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...
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column width units 1
If column width is 8.43, what should the row height be to make a square? 3
Column width in pixels how? 2
Seeking Help with Cell/Range Height and Width Properties 4
Auto Column width for new sheets in workbook? 2
Column Width 3
Excel 2007 default column width different to 2003 1
Code to adjust column width 7

Top