| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Macro to Replace/Delete Text Using "Watchword" List? | Excel Discussion (Misc queries) | |||
| Any way to use toolbar button to delete cells and move cells "up"? | Excel Discussion (Misc queries) | |||
| Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
![Tim H[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
