Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

In this video I explain how to use VBA to delete rows based on cell values or conditions. Download the Excel file that contains the sample code: https://www.excelcampus.com/vba/delete-rows-cell-values/

This is a simple two step process to apply a filter to a range or Table, then delete the visible rows. In the video I explain the VBA code to automate the process with a macro.

I also share more a few advanced macros that:
1. Display a message box with the number of rows to be deleted.
2. Apply filters to multiple columns to delete cells based on multiple conditions or criteria.

To filter the range or Table we use the AutoFilter method in VBA.

We then use the SpecialCells method to select the visible cells and delete the entire rows from the range.

****Free webinar on Macros & VBA****

If you're new to macros and/or want to learn more, join me for a free upcoming webinar on "The 7 Steps to Getting Started with VBA".

You will learn how to write your first macro and go beyond the limitations of the macro recorder.

Click here to register: https://www.excelcampus.com/macros-webinar-yt

****************************************************************

Here are some links and resources:

Articles on the AutoFilter method in VBA: https://www.excelcampus.com/vba/macros-filters-autofilter-method/

Video on how to copy & paste visible cells only: https://youtu.be/9k5Zngv_ulE

Delete entire blank rows: https://youtu.be/NGDhSvEuphM

Copy and paste to another workbook with VBA: https://youtu.be/9R0_h_aoSAE

Add a Yes/No message box before a macro runs: https://youtu.be/rCh7ki9yVsM
00:00 Introduction
00:10 VBA Macro to Delete Rows Based on Cell Values
01:01 The Process Explained
05:43 The VBA Macro Code