Auto fit row according to a specific column

[jcg31]

I have content in column 3 row 5 that would autofit to a row height of 18 pixels in column 8 the content would require 50 pixels (same row). I want the row to autofit to 18 pixels. Is there way to autofit a row according to a specific cell?

Thanks,
Jim

 

[AlphaFrog]

This macro inserts a blank row at row 6
Copies C5 to C6
Autofits row 6
Make the height of row 5 the same as row 6
Deletes row 6

Sub Autofit_Height_C5()
    Application.ScreenUpdating = False
        Rows(6).Insert
        Range("C6").Value = Range("C5").Value
        Rows(6).AutoFit
        Rows(5).RowHeight = Rows(6).RowHeight
        Rows(6).Delete
    Application.ScreenUpdating = True
End Sub