| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for deleting rows?
Phillip wrote:
<<You may be interested in this solution as it is very fast due to no physical looping of rows. Not quite true. The code ... Do While Not IsError(Application.Match... Rows(Crow).Delete Loop .... is, in fact, a loop. It selects each matching row, one by one, and deletes them, one at a time. Data Autofiltering techniques may be faster, but take a little more effort to set up. -- Regards, Bill Renaud |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting rows in two columns with a code in visual basic | Excel Discussion (Misc queries) | |||
| VBA Code for deleting rows with specific value | Excel Programming | |||
| Code deleting all rows in error | Excel Programming | |||
| Help with Chip Pearson's Code for Deleting Blank Rows | Excel Programming | |||
| VBA code for Deleting rows by verification | Excel Programming | |||
Threaded Mode
