Hide row when cell is emtpy

H

Hannes Heckner

I want to define a row range in which a row is hidden when a certain cell in
this row is empty.

any suggestions?

Best regards
Hannes
 
M

Mark Rosenkrantz

Hannes;

Something like

If Isempty(ActiveCell) Then
ActiveCell.EntireRow.Hidden= True
End If

Mark.
 
B

Bob Phillips

Hannes,

Like this?

For i = 1 to 100
If cells(i,"H").Value = "" then
cels(i,"H").entirerow.visible = false
End if
Next i

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top