Liam Birkett
New Member
Hi folks
I am trying to get row heights to automatically adjust to text that is returned using a formula (e.g. VLOOKUP)
I've looked at some online responses, but unable to find anything that works. The following VBA appears to adjust rows to the default height and cuts off half the text:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Rows().AutoFit
End Sub
Any help would be very much appreciated
Many thanks
I am trying to get row heights to automatically adjust to text that is returned using a formula (e.g. VLOOKUP)
I've looked at some online responses, but unable to find anything that works. The following VBA appears to adjust rows to the default height and cuts off half the text:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Rows().AutoFit
End Sub
Any help would be very much appreciated
Many thanks