NOT A VBA Question, I need to delete a row which has a certain cell value, can anyone guide me in the right direction?
 

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.

NOT A VBA Question, I need to delete a row which has a certain cel
 

See Excel VBA help on the FIND method to find a value

See Excel VBA help on Autofilter if you want to filter on a specific value.

You will have to translate it to .NET

--
Regards,
Tom Ogilvy


"LJ" wrote:

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.