VBA Macro to Delete Rows Based on Cell Values

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

Видео VBA Macro to Delete Rows Based on Cell Values канала Excel Campus - Jon