finding a cell has a wrong reference.

Y

Young-Hwan Choi

Hi.

I'm using Excel 2003.
My worksheet has many error cells, mainly about "formula refers to an empty
cell."
I'd like to delete the contents using macro. But, I don't know how to locate
the cells.
Could any one teach me? Or is there any better method to clear the contents?

thanks.
 
A

Anders S

Young-Hwan Choi,

One way to get rid of *all* errors:
- select all cells
- do Edit>Goto>Special, choose Formulas + Errors (or something similar)
- click OK
This will select *all* errors on the sheet, just press Delete and they are gone.

HTH
Anders Silven
 
Top