ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Measuring Column Width (https://www.excelbanter.com/excel-programming/351758-measuring-column-width.html)

Martin in Frisco Texas[_2_]

Measuring Column Width
 
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

Gary Keramidas

Measuring Column Width
 
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



--


Gary


"Martin in Frisco Texas" wrote
in message ...
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




Norman Jones

Measuring Column Width
 
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

---
Regards,
Norman



"Martin in Frisco Texas"
wrote in message ...
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




Martin in Frisco Texas[_2_]

Measuring Column Width
 
Norman

Thanks

Martin

"Norman Jones" wrote:

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

---
Regards,
Norman



"Martin in Frisco Texas"
wrote in message ...
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





Martin in Frisco Texas[_2_]

Measuring Column Width
 
Gary

Thanks

Martin

"Gary Keramidas" wrote:

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



--


Gary


"Martin in Frisco Texas" wrote
in message ...
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






All times are GMT +1. The time now is 05:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com