| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete rows
I have a sheet with (extract from ERP system) with about 30,000 rows. I need
to delete a lot of them (once a week). Tried the following formula: =IF(AND(ISNUMBER(C2412),NOT(ISTEXT(B2412))),"","x" ) copied to for example AA1:AA30.000 to get 'x' in rows to be deleted. Then I use AutoFilter to find all 'x' and try to delete all these rows, but my Excel to freezes. Next I wanted to use Ron de Bruin's code http://www.rondebruin.nl/delete.htm but I am not sure how to change the code to have it delete rows which both have a number in column C and where column B is not text. Am I right that Ron's code is optimized for speed? Hans Knudsen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hpw do I delete multiple empty rows found between filled rows? | Excel Worksheet Functions | |||
| Delete Rows if any cell in Column H is blank but do not Delete Fir | Excel Programming | |||
| Copy pasting Rows, but need to Delete any Shapes/Pictures that are within copied rows | Excel Programming | |||
| How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
| Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming | |||
Threaded Mode
