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

Excel VBA Macro: Delete Rows (Based on List of Values) 💥Subscribe: https://youtube.com/@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