Hi,
I know how to set the rowheight of a row to zero using macro.
Is there a way to do this in the formula section?
Something like :
if there is a value in cell A2 then delete the row or set the height of the row to zero.
p.s. no macro is allowed for business reasons.
Thanks