Macro to Clear Rows Where Total In Col D sums to Zero

i have a macro to clear all data from row 2 in the sum of the values in Col D sums to zero

Please Login or Register  to view this content.

when running the macro the data is not being cleared even though the total values sums to zero


It would be appreciated if someone could kindly amend my code

I don't know if I understood you correctly.
If the sum of the values in column D is 0, then remove the data from row 2:

Please Login or Register  to view this content.

Artik

Hi Artik

I meant that If the sum of the values in column D is 0, then remove the data from row 2 onwards i.e from row 2 until the last row containing data

In that case:

Please Login or Register  to view this content.

Artik

Many thanks Artik. your code works perfectly