Column B with many cells . Every cell has a number . If given number is found
, the macro should delete entire row

I want another macro which makes the opposite : if given number is found ,
keeps the row , but delets the rest