Hide row if all cells in another range are blank
This can easily be modified for any range and row:
Sub dford()
If Application.WorksheetFunction.CountA(Range("A4:A8" )) 0 Then
Else
Rows(3).EntireRow.Hidden = True
End If
End Sub
--
Gary''s Student
gsnu200703
"dford" wrote:
I would like to hide a row if all cells in another range are blank. Example:
If A4:A8 are all blank, then hide row A3.
|