• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Automatic Row Height Adjustments

L

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 :)
 
You must log in or register to reply here.
Back
Top