VBA to Check and Resize Row Height

[purceld2]

Hi There,

I wonder if anybody can help me with a bit VBA

I have a spreadsheet that has a userform which inserts a new line of data at the bottom. What I am after is a bit of VBA that auto fits the text in the inserted row columns M with a minimum row height of 40.

I can record a macro to auto fit the text in the cell, but if there is only one row of text the auto fit makes the row height to thin and packed together that why i need the VBA to check the height which I do not know how to do

Thanks in advance for any help.

Regards