Hi, I have tried searching forum and have found lots of similar questions and answers but nothing exactly like what I would like to do. Unfortunately, I'm not experienced enough to tweak these similar queries to suit my needs.

In cells A15:A130 I have a list of zeroes and ones. I simply want to select all the cells which contain a zero in that range and then delete those entire rows.

I normally just record macros but I don't know how to do this even without the code. I can find and select all blanks in the range and then delete those rows, but as these cells contain a formula they are not being recognised as blanks even if I use "". Hence why I think I need to use a macro.

If somebody could give me the necessary code that would be great and I will try to decipher it myself. Or if someone has more time, I would really appreciate an explanation of the code.

I am a complete novice, and usually work just by recording macros.

Thanks in advance for any help.