hide a row

[Richard]

Is there a formula to hide a row without writing a procedure in the code.
Example: If A1 is blank don't hide, if anything is in A1 hide. Thanks in
advance.

 

[Max]

Physically hide, no. Camouflage using CF, yes, via selecting entire rows
(with A1 active) then using Formula Is: =ISBLANK($A1), and formatting the
font color to be the same as the underlying fill color (to blend).

If above helps in some way, do click the YES button below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik

 

[JLatham]

Max gave the correct answer, plus there's one other consideration: if the row
you want to hide happens to be the same row with the value to test, how are
you ever going to unhide it after it's been hidden? Can't see the cell to
remove the entry in it - you'd have to resort to using Format Rows Unhide.

Just a passing thought.