Rowheight Change: Macro or Cond Format?

[tdhaberk]

I want to (i) select a row; (ii) check for text; (iii) if blank; (iv) change the row height to a specified value. What is the best way to do this? Macro?

Thanks for your help, Excel Novice.

 

[VoG]

Hello and welcome to MrExcel.

see http://www.mrexcel.com/forum/showthread.php?t=402605

 

[tdhaberk]

Thanks. Worked like a charm.