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

"Dan" wrote:

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" wrote:

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