Cell sizing

[JackReacher85]

Hi guys,

Ive got the below formula

=VLOOKUP(C20:C22,Sheet2!A1:B21,2,0)

Which returns the results i need and it works as it should, however when the formula returns the values the cell doesnt show the entire result, and what im looking to do is have the cell automatically adjust so it fits all of the result so it can be read by the user. I know that Excel has the auto fit option in the format tab but this requires the user to manually do this every time the formula is run.

Any ideas on how i can have the cell expand and contract accordingly to the result that is populated in the cell?

Thanks in advance

 

[Skyybot]

Which cell is the formula in?

 

[Skyybot]

Paste this code into the Worksheet that the formula is in.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("A1") Then       <----------Change the value to match the cell that your formula is in.
    Columns(1).AutoFit                   <----------Change the value to match the column number that your formula is in.
End If
End Sub