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

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

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

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

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

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