Code to delete row based on len of cell

**jack.a** · 04-15-2021, 11:26 AM

Hey,

So here is the code I'm using, im usually running it on about 20k cells at a time.

is there a way to speed up this code?

thank you!

Please Login or Register  to view this content.

**Bernie Deitrick** · 04-15-2021, 05:15 PM

Deleting rows is the worst process for Excel to handle - it has always been problematic. After every row deletion, Excel rebuilds its calculation tree, and that is a process that takes time.

The key is to use a column of formulas to label the correct rows for deletion, then sort the data based on the formula to group the rows needing deletion into one block - one deletion, one rebuild of the calculation tree.

Code is this, based on yours with some of my other preferred changes:

Please Login or Register  to view this content.

**jack.a** · 04-19-2021, 09:51 AM

Thank you so much! works like a charm!

Code to delete row based on len of cell

LinkBack

Thread Tools

Rate This Thread

Display

Code to delete row based on len of cell

Re: Code to delete row based on len of cell

Re: Code to delete row based on len of cell

Thread Information

Users Browsing this Thread

Similar Threads

VB code to insert/delete number of rows based on cell value

[SOLVED] Code to delete row based of cell criteria

[SOLVED] Help with Code to delete selected ran=ge based on Value of the cell

VBA code to delete the FILTERED range and moving the cell up (dont Delete entire row)

[SOLVED] VB code to delete value in a cell based on finding another Value

VBA code to find and delete cell contents based on userform combobox selections

Code to delete rows based on status code in Column I

Bookmarks

Bookmarks

Posting Permissions