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

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top