Get free YouTube views, likes and subscribers

Get Free YouTube Subscribers, Views and Likes

Delete Rows based on Value/Text // Excel VBA Tutorial

Follow

Data Nik

In this video I am showing you how to delete rows based on value or text. The code is the following:
Sub delete_rows()

For i = 2 To Sheets(2).UsedRange.Rows.Count
If Cells(i, 3).Value = "No" Then
Rows(i).EntireRow.Delete
End If
If Cells(i, 3).Value = "No" Then
Rows(i).EntireRow.Delete
End If
Next i

End Sub

posted by 2zemlwu

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

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

Delete Rows Based On Criteria Excel VBA Macro

Delete Rows Based On Criteria Excel VBA Macro

Excel VBA IF THEN Statement (with ELSEIF & Looping in cells)

Excel VBA IF THEN Statement (with ELSEIF & Looping in cells)

Run Macro If Cell Value Changes / Excel VBA Tutorial

Run Macro If Cell Value Changes / Excel VBA Tutorial

Excel VBA Macro: Delete Rows if Cell Does Not Contain a Certain Text (String) Value

Excel VBA Macro: Delete Rows if Cell Does Not Contain a Certain Text (String) Value

Deleting Empty Rows in Excel VBA

Deleting Empty Rows in Excel VBA

VBA to Delete Multiple Columns based on Headers Excel VBA Macro Example

VBA to Delete Multiple Columns based on Headers Excel VBA Macro Example

VBA Macro to Delete Rows Based on Cell Values

VBA Macro to Delete Rows Based on Cell Values

Learn Excel VBA to Automate Anything

Learn Excel VBA to Automate Anything

How to get the Last Row in VBA(The Right Way!)

How to get the Last Row in VBA(The Right Way!)

Excel VBA Macro: Delete Rows Based on Cell Value (Zeros and Blanks)

Excel VBA Macro: Delete Rows Based on Cell Value (Zeros and Blanks)

How to Declare (Dim) and Set VBA Variables (use data types correctly)

How to Declare (Dim) and Set VBA Variables (use data types correctly)

Excel: IF Cell Contains Text Then Copy to Another Sheet | Copy Cell Based on Condition

Excel: IF Cell Contains Text Then Copy to Another Sheet | Copy Cell Based on Condition

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

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

Delete (clear contents) in Cells | Excel VBA

Delete (clear contents) in Cells | Excel VBA

Delete Blank Rows Excel VBA Macro

Delete Blank Rows Excel VBA Macro

Excel VBA to Delete Rows if Cell is Blank Delete Rows Based on Cell Value Code Included

Excel VBA to Delete Rows if Cell is Blank Delete Rows Based on Cell Value Code Included

VBA Looping through a Table (ListObject) and deleting a row

VBA Looping through a Table (ListObject) and deleting a row

3 Right Ways to Delete Blank Columns in Excel

3 Right Ways to Delete Blank Columns in Excel

DELETING DATA USING FILTER IN VBA || VBA CODE TO DELETE DATA || FILTER IN VBA || VBA CODE

DELETING DATA USING FILTER IN VBA || VBA CODE TO DELETE DATA || FILTER IN VBA || VBA CODE

Recommended

Awkwardness - The Black Plague Of Today

Awkwardness - The Black Plague Of Today

13:56

And The Oscar Goes To... Twitter Users!

And The Oscar Goes To... Twitter Users!

02:19

Best Guide To Learn How To Shut Up!

Best Guide To Learn How To Shut Up!

02:54

Keep Your Legs Off My Car!

Keep Your Legs Off My Car!

00:20

Belarusian Stuntsman Advertises National Cars As A Boss!

Belarusian Stuntsman Advertises National Cars As A Boss!

01:05

When A Luxurious Life Can't Be Forbidden!

When A Luxurious Life Can't Be Forbidden!

07:17

Best Reason To Delete Your Daily Horoscope App For Ever

Best Reason To Delete Your Daily Horoscope App For Ever

00:02

14 Cats Making Really Weird Sounds

14 Cats Making Really Weird Sounds

01:22