ExcelBanter - quickest way to erase error cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - quickest way to erase error cells (https://www.excelbanter.com/excel-programming/363178-quickest-way-erase-error-cells.html)

Knox

quickest way to erase error cells

I want to erase all cells that contain a divided by zero error. Is a macro
the easiest thing to use? If so could you provide some code? thanx

excelent

quickest way to erase error cells

Press F5
Click the Special button
Mark Formulas
Select only Errors
Ok
Press Delete

Knox

quickest way to erase error cells

awesome! thanx

"excelent" wrote:

Press F5
Click the Special button
Mark Formulas
Select only Errors
Ok
Press Delete

All times are GMT +1. The time now is 08:04 AM.