Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup - finding wrong value | Excel Worksheet Functions | |||
copy-paste started misbehaving (cell reference wrong) | Excel Discussion (Misc queries) | |||
reference is wrong | Excel Discussion (Misc queries) | |||
Finding the cell reference of a matching search value | Excel Worksheet Functions | |||
excel addins have reference to wrong file | Excel Programming |