Delete rows with criteria

[rizmomin]

Hello:

Please refer to attached sheet.

I need VB Code to delete the rows when data in column C and Column D is both Zero.

Please help and let me know if any questions.

Thank you

Riz Momin

[AB33]

Try attached

[HaHoBe]

Hi, rizmomin,

if you use a header line for this you could use the Autofilter to only show and delete all values by that. Alternative: substitue all zeros with blanks and use SpecialCells(xlCellTypeBlanks) to delete the rows.

Please Login or Register  to view this content.

Ciao,
Holger

[rizmomin]

Hi AB33:

Your code will work great, Thank u so much.
Also you have provided a VB Code to my earlier thread "Transpose Data from Sheet1 to Sheet2" and i have question about couple of issues.
Can you please have a look at my questions and help also.

Thank you

Riz Momin