Excel VBA Macro: Delete Rows Faster (Based on Cell Value). In this video, we go over how to delete rows 100x faster than in the previous Delete Rows video. Instead of deleting each row directly, this macro filters the desired data, moves it to another sheet and deletes the original sheet; deleting the undesired rows in the process. This method is best used for large data sets. We use the VBA Timer function to compare the length of time it takes to delete rows using both methods to help us see exactly how much faster this method of deleting rows is.
Data used in this video:
https://simplemaps.com/data/worldcities
Original video "Excel VBA Macro: Delete Rows Based on Cell Value (Zeros and Blanks)":
• Excel VBA Macro: Delete Rows Based on...
#ExcelVBA #ExcelMacro