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