Autosize the column width

  • Thread starter Thread starter Jim Coyne
  • Start date Start date
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
 
ActiveCell.EntireColumn.EntireColumn.AutoFit


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
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)
 
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
 
Back
Top