VB Property Question

[flavioso]

Is there a way in VB that if a value of a cell is equal to 0, it can resize the height of row and highlight it red?

If someone can point me into the direction of the height property, I can probably figure out the code. I appreciate any help.

 

[Joe4]

If you turn on the Macro Recorder, and record yourself changing the height of a row, it should give you the code you need (right click on a row number and select "Row Height").

If you are looking to automate the code, check out this link here:
http://www.cpearson.com/excel/Events.aspx