If your range does not change you should be able to manually set wrap text and auto-fit row heights
- but this is one of those things that can "go out of whack" from time to time
- cells that have always autofitted can suddenly mis-behave without obvious clues as to the cause
- Excel can ignore autofit if row height previously set manually

If a cell is pasted from elsewhere, it takes the formatting of the donating cell etc - which overwrites previous "rules"

I try to avoid formatting complete rows (or columns)
- and format only the range used
- so Range("A4:C30").WrapText = True (rather than Rows("4:30") ....)
- dynamic named ranges are useful if range likely to grow

To reset that range whenever any change occurs in the worksheet - "a sledgehammer to crack a nut"
try putting this into the sheet module of sheet "Finder"
Private Sub Worksheet_Change(ByVal Target As Range)
    With Range("A4:C30")         'amend this to whatever is relevant
        .WrapText = True
        .Rows.AutoFit
    End With
End Sub
If results arrive in those cells via VBA, then as an alternative, include above code instead at end of that procedure (with reference to sheet "Finder")