Automatically changing the height of a row depening on the data in a specific cell

[braderz]

Hi all,

Im looking for a row to be formatted in such a way that the height automatically changes depening how much data is in a cell within that row. The cell in question is wrapped and can either have say from nothing to numerous email addresses present. Almost to have the effect of double clicking the row but for this to happen automatically.
If this is possible your help would be much appreciated, I have looked all over the internet and could only find autofit suggestions which don't work. Is a macro needed?

Many thanks.

 

[braderz]

I have just tried the following which will work however I need it to apply for every row passed row 4?

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)</SPAN>
Range("A:F").Rows.AutoFit</SPAN>
End Sub
</SPAN>
Many thanks in advance,
</SPAN>
</SPAN>
</SPAN>