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

  • Thread starter Thread starter andrei
  • Start date Start date
A

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
 
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.
 
Back
Top