Macro reads cells with numbers . If given number is found , delets

[andrei]

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

 

[Dan]

You want a clue or the answer?

Clue:

Create a looping macro which iterates over each cell from the last to the
first, checks the value of the cell and deletes the entire row if
appropriate. Use integer variables to track which row to delete.

 

[andrei]

Actually i want the answer . My Knowledge in VB is very low