Automated Removal Of Zeros From Spreadsheet

I have several Excel files with longitude values in column A, latitude in B, and data in columns C to DH. There is a lot of data in each file, so I was wondering if someone would be able to design a macro to achieve the following: I want any row containing zeros through column C to DA (not through to DH) to be deleted (deletion of the whole row, including DB to DH) - and the row beneath to be shifted up so no blank rows remain.

However, there are 16 instances where the row contains legitimate zeros and should be preserved in the dataset. These are at the following coordinates, where longitude (column A) is listed first, with latitude (B) second.

6.75, 27.75
8.25, 27.75
23.25, 27.75
24.75, 27.75
-2.25, 26.25
-0.75, 26.25
0.75, 26.25
2.25, 26.25
14.25, 26.25
-5.25, 24.75
-3.75, 24.75
-2.25, 24.75
15.75, 24.75
17.25, 24.75
9.75, 23.25
14.25, 21.75

So just to clarify, please could someone create a macro which deletes a row with zeros present from C to DA and shifts up the row beneath, except in the instances listed above.