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

L

LJ

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.
 
T

Tom Ogilvy

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
 

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

Similar Threads

VBA macro delete row - Help needed 7
Macro to delete entire rows where certain range of cells are blank 2
Macro to delete row if cells greater than certain value 1
Automatically Combine Cell Contents and Delete Rows 0
Move rows based on cell info 4
Code Needed To Loop Through Certain Rows 5
Apply cell formatting using VBA 2
New topic from discussion "Align cells with same value - vba almostworking" in this group 0

Top