Excel search & delete

[Excelprincess]

I have an excel spreadsheet and I wish to delete cells with a value of "n" with one command. Example: I want to delete all rows that have a value of 1.
How might this be accomplished?

 

[KenWright]

Might have to elaborate on the 'one command' bit. You can do what you want manually with Data / Filter / Autofilter / 1, then select the range of 1s and do Edit / Go To / Visible cells only, then Edit / Delete / Entire row.

This can also be automated such that you either get a prompt for the value n, or if you have already put it in a cell it can simply use that value for the filter, or it can just be hardcoded into the routine. Where do you want to go?

Regards
Ken...............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[Excelprincess]

Thanks, Ken. I will try your first suggestion.

ExcelPrincess