Excel VBA Macro: Delete Rows If Any Cell in Those Rows (Across All Columns) Contains a Certain Value

Excel VBA Macro: Delete Rows If Any Cell in Those Rows (Across All Columns) Contains a Certain Value
💥Subscribe: / @greggowaffles
Code:
Sub delete_rows_across_all_cols()
Dim row_count As Long
Dim col_count As Long
Dim i As Long
Dim j As Long
Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets("NYSE Stocks")
ws.Activate
row_count = ws.Cells(Rows.Count, 1).End(xlUp).Row
col_count = ws.Cells(1, Columns.Count).End(xlToLeft).Column
i = 2
Do While i ＜= row_count
For j = 1 To col_count
If Cells(i, j) = "" Then
Rows(i).EntireRow.Delete
i = i - 1
row_count = row_count - 1
End If
Next j
i = i + 1
Loop
End Sub
#excelmacro #excelvba

[@sakhilengwenya594]

Thank you 🙏

[@alexrosen8762]

Superuseful 👌Thanks 🙏

[@greggowaffles]

Appreciate the feedback! Thank you!!

[@deepk82]

Wow that's great. Very useful. I'm very good at the excel formula, charts, pivot tables and several years ago, I tried learning VBA code but stopped because I wasn't getting the basics so left in between. After watching your videos I am getting a strong feeling to start again. Can you help me again by explaining the basics of defining variables Dim long, string, integer etc. and if , while, looping etc. Thanks in advance. Deep

[@greggowaffles]

Absolutely! Happy to help

[@deepk82]

How should I begin?

[@greggowaffles]

@@deepk82I recommend just jumping right in and start building your own macros to automate some manual tasks you might have. You’ll learn from your mistakes, and you’ll figure out multiple ways to achieve the same results. Don’t let “analysis paralysis” get to you! 😊