VBA to adjust Row Height

[Bob]

I am new to writing VBA and I am having trouble writing code that
achieves the following:

If text in D2>115 characters then adjust row D's height to 30, else
row height remains 20

followed by the same if then statment for rows E thru M (i.e., If
M2>115 Then Row M height = 30

Any suggestions would be greatly appreciated.

 

[Frank Kabel]

Hi Bob
you are tlaking about columns but you want to change the row height?
I asume you're talking about row 2 (in your example?). Note you can't
change the heigth of a row individually per column. If you change it it
will apply for all columns.
So maybe you could clarify this a little bit more. A macro should then
be easy to derive