VBA: How to delete filtered rows in Excel?

by

Use SpecialCells to delete only the rows that are visible after autofiltering:

ActiveSheet.Range("$A$1:$I$" & lines).SpecialCells _
    (xlCellTypeVisible).EntireRow.Delete

If you have a header row in your range that you don’t want to delete, add an offset to the range to exclude it:

ActiveSheet.Range("$A$1:$I$" & lines).Offset(1, 0).SpecialCells _
    (xlCellTypeVisible).EntireRow.Delete

More Related Contents:

  1. Unprotect VBProject from VB code
  2. Assign event handlers to controls on user form created dynamically in VBA
  3. Round function in Excel, worksheet function vs VBA
  4. Excel VBA Userform – Execute Sub when something changes
  5. simple vba code gives me run time error 91 object variable or with block not set
  6. VBA Function argument list select
  7. Excel VBA wildcard search
  8. Reading Web Pages using Excel VBA
  9. How do I get values from a hidden worksheet using VBA [closed]
  10. How to copy cells that contain certain text to another worksheet [closed]
  11. VBA Macro for copying and pasting columns on same excel sheet
  12. Excel VBA, code to count the # of filled cells, then find highest and 2nd highest and subtract the corresponding column #’s [closed]
  13. Levenshtein Distance in VBA [closed]
  14. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  15. How do I base64 encode a string efficiently using Excel VBA?
  16. Conditional Formatting using Excel VBA code
  17. Controlling IE11 “Do you want to Open/Save” dialogue window buttons in VBA
  18. How to “flatten” or “collapse” a 2D Excel table into 1D?
  19. How do I use variables to set properties in VBA (Excel)
  20. VBA: Else without If Error
  21. Workbooks.Open Method in VBA
  22. Windows().Activate works on every computer except one
  23. Cannot VBA write data to cells in Excel 2007/2010 within a function
  24. Convert RTF (Rich Text Format) code into plain text in Excel
  25. lastrow and excel table.
  26. Excel: the Incredible Shrinking and Expanding Controls [closed]
  27. Open a workbook from VBA and disable Workbook_Open() code?
  28. Creating form programmatically in the module using vba
  29. How to filter listbox values based on a Textbox value
  30. VBA inheritance, analog of super

Leave a Comment