Delete entire row if cell C has data = 0

**rflorent** · 03-31-2014, 12:50 PM

Hi can guys can you help me with this one. Code below

Please Login or Register  to view this content.

Error says object required

many thanks.

**Solus Rankin** · 03-31-2014, 01:03 PM

Please Login or Register  to view this content.

**rflorent** · 03-31-2014, 01:15 PM

Originally Posted by Solus Rankin

Please Login or Register  to view this content.

What if Cell(i, 3) is equal to zero sir. How will I write the code? Is it still If Not Isempty?

**Solus Rankin** · 03-31-2014, 01:18 PM

Please Login or Register  to view this content.

**rflorent** · 03-31-2014, 01:34 PM

Another question sir. Take a look at my code.

Please Login or Register  to view this content.

I want only to have that formula only if C cell is not equal to 0..there are many 0 in column c since im referencing it only.

**Solus Rankin** · 03-31-2014, 01:36 PM

Is the 0 in column C a product of a formula?

Re: Delete entire row if cell C has data = 0