Hide row when cell is emtpy
 

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

Hide row when cell is emtpy
 

Hannes;

Something like

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

Mark.

--
More Excel ? www.rosenkrantz.nl or
-------------------------------------------------------------------


"Hannes Heckner" wrote in message
...
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

Hide row when cell is emtpy
 

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)

"Hannes Heckner" wrote in message
...
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