Need help deleting rows containing specific data

[Henner]

Hi

Firstly, a message for Jim North if you read this. Many thanks for the macro you provided me with today - it does a great job.
------------------------

I need to delete all rows where a cell in column A contains the word BITS, and a zero exists in the cell in column D - on the same rows only. I do not want to delete any rows where there is a zero in column D but the word BITS doesn't exist in cells in column A.

I know this can be done using AutoFilter and filtering on columns A and D. The problem is the file contents changes each day so if I use AutoFilter, delete the relevant rows and record it in a macro, it may not delete the correct rows the next day.

Can anyone provide me with some VBA code I can copy into a macro which searches for the word BITS and a zero on the same row and deletes these rows?

Thank you,
Paul

 

[Juan Pablo González]

I would still use an Autofilter in a macro, BUT, I would select the ENTIRE columns, instead of just the current area. That way your macro would still work after that. Make sure that you use the Visible Cells only feature too to make it as general as possible.

 

[Henner]

Thank you very much for your help, Juan,

I wasn't aware of the Special features in the 'Go To..' section before. These have helped me solve some other problems as well.

Best regards,
Paul