Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Measuring cell width and height for printed paper Pekka Numminen Excel Discussion (Misc queries) 6 March 1st 10 10:32 PM
Change Cell Width WITHOUT changing Column width dww701 Excel Discussion (Misc queries) 1 January 12th 09 10:52 PM
How to make cell width different than the column width it lies in John Excel Discussion (Misc queries) 2 September 11th 06 10:41 PM
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 07:25 PM


All times are GMT +1. The time now is 04:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"