Is there a way to automatically re-size the width of a column to fit the
widest entry, like when you double-click on the column separators?

Thanks

Jim

Hi Jim
record a macro whild doing this manualy and use this kind of code

--
Regards
Frank Kabel
Frankfurt, Germany


Jim Coyne wrote:
Is there a way to automatically re-size the width of a column to fit
the widest entry, like when you double-click on the column
separators?

Thanks

Jim

ActiveCell.EntireColumn.EntireColumn.AutoFit


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Frank Kabel" wrote in message
...
Hi Jim
record a macro whild doing this manualy and use this kind of code

--
Regards
Frank Kabel
Frankfurt, Germany


Jim Coyne wrote:
Is there a way to automatically re-size the width of a column to fit
the widest entry, like when you double-click on the column
separators?

Thanks

Jim

Hi Bob
not
ActiveCell.EntireColumn.AutoFit

:-)


--
Regards
Frank Kabel
Frankfurt, Germany


Bob Phillips wrote:
ActiveCell.EntireColumn.EntireColumn.AutoFit



"Frank Kabel" wrote in message
...
Hi Jim
record a macro whild doing this manualy and use this kind of code

--
Regards
Frank Kabel
Frankfurt, Germany


Jim Coyne wrote:
Is there a way to automatically re-size the width of a column to
fit
the widest entry, like when you double-click on the column
separators?

Thanks

Jim

Not my day, but it does work(sic!).

You not what they say, so good I did it twice.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Frank Kabel" wrote in message
...
Hi Bob
not
ActiveCell.EntireColumn.AutoFit

:-)


--
Regards
Frank Kabel
Frankfurt, Germany


Bob Phillips wrote:
ActiveCell.EntireColumn.EntireColumn.AutoFit



"Frank Kabel" wrote in message
...
Hi Jim
record a macro whild doing this manualy and use this kind of code

--
Regards
Frank Kabel
Frankfurt, Germany


Jim Coyne wrote:
Is there a way to automatically re-size the width of a column to
fit
the widest entry, like when you double-click on the column
separators?

Thanks

Jim

Yes, that worked. I'm sure I had tried it before, but I think I was getting
the object syntax messed up, and VB was not helping me out any with .

Thanks

Jim

"Bob Phillips" wrote in message
...
Not my day, but it does work(sic!).

You not what they say, so good I did it twice.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Frank Kabel" wrote in message
...
Hi Bob
not
ActiveCell.EntireColumn.AutoFit

:-)


--
Regards
Frank Kabel
Frankfurt, Germany


Bob Phillips wrote:
ActiveCell.EntireColumn.EntireColumn.AutoFit



"Frank Kabel" wrote in message
...
Hi Jim
record a macro whild doing this manualy and use this kind of code

--
Regards
Frank Kabel
Frankfurt, Germany


Jim Coyne wrote:
Is there a way to automatically re-size the width of a column to
fit
the widest entry, like when you double-click on the column
separators?

Thanks

Jim