How to delete multiple rows without a loop in Excel VBA

by

This will delete row numbers m to n passed through the function

Sub Delete_Multiple_Rows (m as Integer, n as Integer) 

    Rows(m & ":" & n).EntireRow.Delete 

End Sub

More Related Contents:

  1. Sequence of numbers based on start and end value of 2 cells [closed]
  2. Function to convert column number to letter?
  3. Better way to find last used row
  4. 2 Dimensional array from range [closed]
  5. How can I create a calendar input in VBA Excel?
  6. Using Google Chrome in Selenium VBA (Installation Steps)
  7. Dir() function not working in Mac Excel 2011 VBA
  8. How to use workbook.saveas with automatic Overwrite
  9. Range limit conundrum
  10. How do you run a .exe with parameters using vba’s shell()?
  11. How to determine the last Row used in VBA including blank spaces in between [duplicate]
  12. How to use FindWindow to find a visible or invisible window with a partial name in VBA
  13. How do you get a Range to return its Name?
  14. Passing variable from Form to Module in VBA
  15. How to give a time delay of less than one second in excel vba?
  16. Changing the date format to yyyy-mm-dd
  17. Referencing Excel Userform Control Name Value From String (VBA)
  18. Loop through each row of a range in Excel
  19. Fill formula down till last row in column
  20. Outputting Excel rows to a series of text files
  21. How to create a range from two ranges in VBA?
  22. XML parse VBA excel (function trip, & MSXML2.DOMDocument)
  23. If string contains word from list, return value adjacent to list value
  24. Refreshing all the pivot tables in my excel workbook with a macro
  25. Countif With Multiple OR Criteria
  26. excel vba freeze pane without select
  27. Converting a string representation of a constant into a constant?
  28. VBA WinHTTP to download file from password proteced https website
  29. How to protect Excel workbook using VBA?
  30. How to get the range of the visible rows after applying an advanced filter in Excel (VBA)

Leave a Comment