Autosize the column width

J

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
 
B

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)
 
B

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)
 
J

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
 
Top