quickest way to erase error cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Press F5
Click the Special button
Mark Formulas
Select only Errors
Ok
Press Delete
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need macro: erase the last 10 digits of active cell then down 1 2
Auto Detect Data, Auto Print Data, Auto Erase Data Loop 8
Identifying Machine or Location When a Procedure is Run 6
Evaluate a range of cells for true or false condition (Div/0) 3
Save Array in memory 5
Code to delete names works in one WB, but not another WB? 2
Conditional Formatting and VBA 4
Share and protect 1

Back
Top