delete row if condition

  1. M

    Delete Row based on Last Word

    Hello all, i want to delete the entire row if last word is not equal to "OK". I have created a macro, but it is deleting all the rows in the column instead of particular rows where last word is not equal to "OK". Thank you Sub DelD() Dim cel As Range Dim Rng As Range Set Rng = Range("A2:A" &...
  2. D

    Macro to delete rows based on cell values in a range - dynamic rows and columns

    Hello team, I would like to ask for help with the following macro as I just can't figure it out, I tried so many versions but nothing worked for me. I need to remove all rows in my sheet that do not contain value greater than 50 in any cell in a given row. That means that if the value is less...
  3. T

    VBA - Search workbook for list in sheet1, and delete all rows containing those values

    I found similar requests here, but nothing that I could make work for what I needed. I have a list of over 200 inactive part numbers (and more may need to be added) in Sheet1 column A. In all other sheets in the workbook I want to search through column C, starting at row 8, and delete the row...
  4. F

    Deleting rows based on a variable in 1 column

    hello, I have created some code that will delete an entire row based on if the value 1 is in the column or not. The code works but takes 40 minutes to run on 300,000 lines. Is there a better method to make this work? Sub Delete_Rows() Dim i As Long Dim LastRow As Long...
  5. S

    VBA delete row if date contained however skip if blank

    Hello, I am looking for a vba that will do the follow. If the cell a2 date value is not the date value of the cells below delete the row however if the cell is blank within the column do nothing and move on to the next cell. <tbody> a b 1 2 7/22/2019 21:04 3 7/22/2019 20:55 4...
  6. L

    Repeat until value not found in column

    Hello everybody I need same help. I need to delete rows with the value 0 in column B I made this: Columns("B:B").Select Selection.Find(What:="0", After:=ActiveCell, LookIn:=xlValues, LookAt:= _ xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _...
  7. G

    VBA delet avery 11 value if not text( or if number is true), and loop on

    Hi , my question is how to loop through the range( column) and delete every 11th value if it is a number, or if it is not a text( both works). Product product name 123 123 1234 435 564 234 345 3245 NONO 234 So here on the 11th row, I have a text I would like it to be deleted ( whole row) if...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top