So my research has helped me acquire this code -

Private Sub Worksheet_Change(ByVal Target As Range)
Target.EntireRow.AutoFit
End Sub
Simple enough, i have this as i have wrap text in certain columns but how do i apply this to just a column or just a cell? the current code applies to the whole sheet and unfortunately some of the columns cannot auto adjust row height for layout purposes.


Any and all advice appreciated.