Autofit does not work when cell is updated automatically.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list in Column A that, when I choose an item, I automatically update
information in Column B. I have selected autofit, but when Col B is updated
is wont autofit. If I select the same item from Col A again then it will. Not
good for the users!
 
A formula that changes won't make the size of the column change.

Maybe you could have an event macro that runs each times that worksheet
recalculates.

If you want to try that event macro, you can rightclick on the worksheet tab
that should have this behavior. Select view code and paste this in:

Option Explicit
Private Sub Worksheet_Calculate()
Me.Columns.AutoFit
End Sub
 
Back
Top