Excel VBA Macro: Delete Rows (Based on List of Values)

💼 Hire Me for Excel VBA Automation Need help automating your Excel workflows? I specialize in building custom Excel VBA solutions to save you time and eliminate repetitive tasks. 👉 https://www.upwork.com/freelancers/~0... Excel VBA Macro: Delete Rows (Based on List of Values) 💥Subscribe:    / @greggowaffles   Code: Sub delete_rows_based_on_list() Dim ws1 As Worksheet Dim ws2 As Worksheet Dim row_count1 As Long Dim row_count2 As Long Dim i As Long Dim j As Long Set ws1 = ThisWorkbook.Sheets("Stock Screener") Set ws2 = ThisWorkbook.Sheets("Items to Delete") ws2.Activate row_count2 = ws2.Cells(Rows.Count, "A").End(xlUp).Row ws1.Activate row_count1 = ws1.Cells(Rows.Count, "A").End(xlUp).Row For j = 1 To row_count2 i = 2 Do While i ＜= row_count1 If Cells(i, 10) = ws2.Cells(j, 1).Text Then Rows(i).EntireRow.Delete i = i - 1 row_count1 = row_count1 - 1 End If i = i + 1 Loop Next j End Sub #excelmacro #excelvba