Hiding Macaroni

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Thanks again for all the help. I've got another question though.

How to I hide an entire row (A16) if A17 - A23 ALL have vaules that = 0 (Not
null but the number zero).

Thanks again,
Bob
 
Hi Bob

Don is right about the subject <g>

Sub test()
If Application.WorksheetFunction.CountIf( _
Range("A17:A23"), "0") = 7 Then _
Rows(16).Hidden = True
End Sub
 
Will do. Sorry about that. I'll make it more descript. Thanks again for
the help, I really appreciate it. I'll try this one out too.

-Bob
 
Back
Top