delete entire row if #DIV/0! detected

[delgado]

Hello
I need a vba script to delete entire row if #DIV/0! is detected in any cell of the last column

Any hint is greatfully appreciated

[DonkeyOte]

Are the #DIV/0! values formula results rather than constants ?

If so are there any other error results you wish to preserve (eg #VALUE! etc...)

If not you should consider using SpecialCells(xlCellTypeFormulas,xlErrors) to identify the rows to delete and process all offending rows simultaneously.
(note limitation on non-contiguous areas: http://www.rondebruin.nl/specialcells.htm)

Worth adding that it would be wise to toggle Events, Screenupdating & Calculation when you do this.

If you need more assistance it would be wise to post a small sample which illustrates your present set-up (specifically whether the cells are formulae or constants).

[Leith Ross]

Hello delgado,

Here is a macro that will delete any row that has a #DIV/0! error in the last column.

Please Login or Register  to view this content.

Adding the Macro

1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
   
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

[delgado]

[SOLVED]
Thank you very very match

[delgado]

Thanks you very very match