#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 144
Default col width

Hi all,

I want to know the existing col width, what code do I need?

TIA

Jack Sons
The Netherlands


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 834
Default col width

Try

activecell.ColumnWidth

--

HTH

Bob

"Jack Sons" wrote in message
...
Hi all,

I want to know the existing col width, what code do I need?

TIA

Jack Sons
The Netherlands



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 144
Default col width

Thanks Bob.

Jack.

"Bob Phillips" schreef in bericht
...
Try

activecell.ColumnWidth

--

HTH

Bob

"Jack Sons" wrote in message
...
Hi all,

I want to know the existing col width, what code do I need?

TIA

Jack Sons
The Netherlands





  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default col width

MsgBox ActiveCell.EntireColumn.ColumnWidth
--
HTH...

Jim Thomlinson


"Jack Sons" wrote:

Hi all,

I want to know the existing col width, what code do I need?

TIA

Jack Sons
The Netherlands


.

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
Change Cell Width WITHOUT changing Column width dww701 Excel Discussion (Misc queries) 1 January 12th 09 10:52 PM
Concvert Full Width Katakana characters into Half Width Katakana C Mandeep Dhami Excel Discussion (Misc queries) 0 November 30th 07 06:47 AM
Data-Validation-List-Width of list must be colomn width, is this possible Luc Excel Worksheet Functions 2 March 5th 07 05:49 PM
ASC() does not convert full-width to half-width letters (Exel 2003 DY Excel Worksheet Functions 0 January 27th 07 01:34 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


All times are GMT +1. The time now is 02:17 PM.

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

About Us

"It's about Microsoft Excel"