I am new to programming and macro's.

Can anyone help me with the following problem.

I have on sheet three multiple items listed from row 5 to 6886.

Column AO to AZ have the quantities on hand for specific dates.

How do I hide a row if AO to AZ all contain the value "0"?