View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Tim H[_2_] Tim H[_2_] is offline
external usenet poster
 
Posts: 20
Default DELETE CELLS w/ "DIV/0" MACRO

Trying to write a macro that will do a 'search and delete' type function for
cells that yield a "DIV/0" error.

What I want to accomplish is a break in the line graph when there is no
data. Problem is that excel 2003 treats anything in a cell other than a
numerical value as a ZERO. Even if I write an IF(ISERROR) function to yield
"", it still treats the cell as a zero value.

The only way to get a break in the line is to actually delete out the
formula completely when there's a "DIV/0" error.

Any suggestions?