ExcelBanter - col width

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - col width (https://www.excelbanter.com/excel-discussion-misc-queries/262616-col-width.html)

Jack Sons

col width

Hi all,

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

TIA

Jack Sons
The Netherlands

Bob Phillips[_4_]

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

Jack Sons

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

Jim Thomlinson

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

.

All times are GMT +1. The time now is 01:26 PM.