Excel VBA Macro: Delete Rows (Based on Cell Values in Multiple Columns)

💼 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/~013bd05e311ebf4a2c

Excel VBA Macro: Delete Rows (Based on Cell Values in Multiple Columns)

💥Subscribe: https://youtube.com/@greggowaffles

Code:
Sub delete_rows_based_on_multi_col()

Dim row_count As Long
Dim i As Long
Dim ws As Worksheet

Set ws = ThisWorkbook.Sheets("Countries")

ws.Activate
row_count = ws.Cells(Rows.count, "A").End(xlUp).Row

i = 2

Do While i ＜= row_count

If Cells(i, 6) = "" _
Or Cells(i, 10) = "" _
Or Cells(i, 5) ＞ 10000 Then

Rows(i).EntireRow.Delete
i = i - 1
row_count = row_count - 1
End If

i = i + 1

Loop

End Sub

#excelmacro #excelvba

Видео Excel VBA Macro: Delete Rows (Based on Cell Values in Multiple Columns) канала greggowaffles