Prev: Autofill formulas when inserting rows in excel tables
Next: spreadsheet problem
From: Jack Sons on 28 Apr 2010 09:12
Hi all,

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

TIA

Jack Sons
The Netherlands


From: Bob Phillips on 28 Apr 2010 09:33
Try

activecell.ColumnWidth

--

HTH

Bob

"Jack Sons" <j.sons(a)planet.nl> wrote in message
news:usdqzRt5KHA.3652(a)TK2MSFTNGP02.phx.gbl...
> Hi all,
>
> I want to know the existing col width, what code do I need?
>
> TIA
>
> Jack Sons
> The Netherlands
>


From: Jack Sons on 28 Apr 2010 09:47
Thanks Bob.

Jack.

"Bob Phillips" <bob.phillips(a)somewhere.com> schreef in bericht
news:en2skdt5KHA.1424(a)TK2MSFTNGP04.phx.gbl...
> Try
>
> activecell.ColumnWidth
>
> --
>
> HTH
>
> Bob
>
> "Jack Sons" <j.sons(a)planet.nl> wrote in message
> news:usdqzRt5KHA.3652(a)TK2MSFTNGP02.phx.gbl...
>> Hi all,
>>
>> I want to know the existing col width, what code do I need?
>>
>> TIA
>>
>> Jack Sons
>> The Netherlands
>>
>
>


From: Jim Thomlinson on 28 Apr 2010 09:58
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
>
>
> .
>
 | 
Pages: 1
Prev: Autofill formulas when inserting rows in excel tables
Next: spreadsheet problem