View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default 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