I need to code a method in VB.NET to delete entire rows of which a cell
in that row contains a certain value. So for instance, I'll try to sum
it up in words

Search through all cells in Column(column index)
If the Cell(rowindex, columnindex).VALUE = "UNWANTEDVALUE"
then DELETE.ROW(rowindex)

Another post had mentioned using a range to delete all rows satisfying
the condition at once.
I'd love to do that, but I can't figure that out either. So if there is
anyone that can help me with either solution, please do so.