Скачать или смотреть Excel VBA Macro: Delete Rows with Zeros or Blanks (Step-by-Step Tutorial)

💼 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 with Zeros or Blanks (Step-by-Step Tutorial). We create a macro that deletes rows based on cell value with specific text. If you ever need to remove all rows that contain a specific value in an excel worksheet, you can use this code to remove those rows.

In this example, we delete rows that contain zeros and delete blank rows specifically. The code searches for a specific value in a designated column, then deletes that entire row if it contains the value you want deleted. The macro counts the number of total rows in the data-set, then goes down each row searching for the specific value in order to delete the entire row, until it reaches the bottom of the range.

💥Subscribe:    / @greggowaffles  

Need help opening the VBA editor?
   • Creating Your First Macro: A Quick Beginne...  

Code:
Sub delete_zeros()

Dim count As Long
Dim i As Long

count = ActiveSheet.Cells(Rows.count, "A").End(xlUp).Row
'msgbox count

i = 1

Do While i ＜= count

If Cells(i, 7) = 0 Then

Rows(i).EntireRow.Delete
i = i - 1

End If

i = i + 1
count = ActiveSheet.Cells(Rows.count, "A").End(xlUp).Row

Loop

End Sub


#ExcelVBA #ExcelMacro