Autosize the column width

[Jim Coyne]

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

 

[Frank Kabel]

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

 

[Bob Phillips]

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]

Hi Bob
not
ActiveCell.EntireColumn.AutoFit

 

[Bob Phillips]

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)

 

[Jim Coyne]

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