VBA code for deleting Rows that contain specific criteria from Filtered Data

Hello,

I am trying to delete the entire row/rows of specific data from a filtered table. As an example, I have data in columns A1:E600. From Column B, I want to delete the rows that contain the text "Active".

I have a used the following macro, but I am stuck when I want to remove the filter. Then filter on a different column and delete the criteria in that column.

Please Login or Register  to view this content.

Can someone please help or refer me to a great link?? Also, if there is a cleaner way than this code, please advise.

Thanks in advance!

Hi

Maybe

Please Login or Register  to view this content.

rylo

rylo,

Thanks, this worked!

Carlos