How to delete rows in Excel using VBA based on the criteria?

Share Now


Most of the time while formatting sheets of data we remove immaterial rows from the data.

So here is the simple example, below macro will delete the all rows containing “Grand Total” in the column A.

To run the macro use following steps:

  • Open VBA (Visual Basic Editor), Press Alt + F11.
  • Go to Insert>Module.
  • Copy the code and paste it in the new module.
  • Press Alt+Q to return to Excels sheets.
  • Push Alt+F8 (Or click Developer Tab > Macros) and then select the macro name and click Run.



Share Now
November 16, 2019

1 responses on "How to delete rows in Excel using VBA based on the criteria?"

  1. hi
    dear

    thanks for that course nice and craze excel
    thanks i like to here more for user form
    thanks all staff.

    raymond

Leave a Message

Your email address will not be published. Required fields are marked *

Social Media

facebook page EC Analytics Consulting   Linkedin Page EC Analytics Consulting   Youtube EC Analytics Consulting

Address:

NM 23, SECTOR 14, OLD DLF COLONY,
GURGAON (HARYANA)
0124- 4601426

ABOUT EC ANALYTICS CONSULTING

EC Analytics will help your business make better decisions by providing expert-level business intelligence (BI) services. Forecasting, strategy, optimization, performance analysis, trend analysis, customer analysis, budget planning, financial reporting and more. EC Analytics also offers Advanced Data Analytics training in corporate and retail.

EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED