finding a cell has a wrong reference.
 

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.

finding a cell has a wrong reference.
 

Young-Hwan Choi,

One way to get rid of *all* errors:
- select all cells
- do EditGotoSpecial, 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

"Young-Hwan Choi" skrev i meddelandet
...
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.