View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Young-Hwan Choi Young-Hwan Choi is offline
external usenet poster
 
Posts: 17
Default 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.