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.
|