Hide rows based on value "0" in multiple columns

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"?

I tried running the script, but it doesn't seem to do anything. I think the logic is correct, but I am to inexperienced to get it sorted myself. I appreciate all the help, maybe I just need to change something, any ideas?

Have you put the code in a module?

Should have mentioned this but you may need to change the sheet references. In the VB editor you should have a project explorer window on the left. This contains the various objects where you can put your code, including sheet objects. In the code above I wrote Sheet3. When you look at the excel objects in the project explorer you will see each sheet has a program name (the first name) followed by a name in brackets (which is the name you see in the tab in the workbook). Sheet3 is a reference to the program name, so you may need to change this to the relevant sheet program name. I have bolded the sheet references in the original post.

Does that make sense?

Just another thought, do the columns contain any text string and can numbers be negatives?

Thanks for that, it makes perfect sense. Rookie mistake on my part. Everything is sorted and working 100%.

Thanks for all your trouble and advise. It is really appreciated.

No problem