Autofit does not work when cell is updated automatically.

[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!

 

[Dave Peterson]

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

 

[Guest]

Dave,

Excellent, I just changes the Columns to Rows for my needs. Thanks so much.

Jim