View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.